Frequent errors(Calcite) while running queries on Virtual Datasets

1

Hey guys,

We have been using Dremio AWS edition(4.5) for last one month, but we are experiencing some weird issues since few days with virtual data sets.

The queries work fine sometimes and fails suddenly sometimes with the below error:

VALIDATION ERROR: Unknown field ‘*’

(org.apache.calcite.runtime.CalciteContextException) At line 1, column 8: Unknown field ‘*’
sun.reflect.NativeConstructorAccessorImpl.newInstance0():-2
sun.reflect.NativeConstructorAccessorImpl.newInstance():62
sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45

Can anyone please help us on this?

Thanks,
Jalandhar

2

please @jalandhar share the query profle of both success and failed

3

Hello @jalandhar,

Is it the exact same query failing sometimes with this error and other times without it?

Otherwise, I would say this is syntax error in your SQL string somewhere.

4

Hey @ben,

Yes, the exact same query is failing some times and giving results some other times.

Thanks,
Jalandhar

5

Hey @dacopan,

Attaching failed query profile for reference. I don’t have success query profile as we ran the same queries few days back for which we don’t have results now.
ebd56414-261f-454b-bda1-259f53f05563.zip (6.4 KB)
Thanks,
Jalandhar

6

@jalandhar

From the profile, I can see it is a HBase table. Are all errors only happening when querying HBase tables

Thanks
Bali

7

@balaji.ramaswamy,

We have stored the data from hbase to s3 and named the location as s3 as a convention but its not an hbase table. So this is not related to hbase table as we have not even integrated Hbase connector with Dremio.

And yes this happening for all tables created from s3 location.

Thanks,
Jalandhar