Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Fail to link a sample table to its base table #1278

Open
xixiz opened this issue Mar 31, 2019 · 0 comments
Open

Fail to link a sample table to its base table #1278

xixiz opened this issue Mar 31, 2019 · 0 comments

Comments

@xixiz
Copy link

xixiz commented Mar 31, 2019

Given two column tables of the same name but different schemas, namely schema1.examples and schema2.examples. Then, for each of them, a corresponding sample table of the same name is created using the following commands.

create sample table schema1.examples_sample on schema1.examples options (qcs 'status’, fraction '0.1') as (select * from schema1.examples);

create sample table schema2.examples_sample on schema2.examples options (qcs 'status’, fraction '0.1') as (select * from schema2.examples);

When querying schema2.examples using "... with error;", the obtained result used schema1.examples_sample instead of schema2.examples_sample.

When deleting both sample tables then querying schema2.examples again with the same query, an error occurred as shown in the following lines.

ERROR 42X05: (SQLState=42X05 Severity=20000) (Server=snappy3/192.168.210.193[1527] Thread=ThriftProcessor-4) Table/View 'SCHEMA.EXAMPLES_SAMPLE' does not exist.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant