So, I added a comment on that JIRA... I have a parquet file, I need to explore it... it comes from another user, I want to be able to explore with select * but I don't know the field names... how can I do this? I know it seems like we should always know the column names, but I don't :)
On Fri, Aug 11, 2017 at 1:33 PM, Vova Vysotskyi <[email protected]> wrote: > Hi John, > > Fix for the DRILL-4264 > <https://issues.apache.org/jira/browse/DRILL-4264> should > solve this issue. This error appears when you try to do *select **. But > while DRILL-4264 <https://issues.apache.org/jira/browse/DRILL-4264> is not > fixed, you can try to do *select `**id.orig_h`*. It should not throw the > error. > > Kind regards, > Volodymyr Vysotskyi > > 2017-08-11 21:07 GMT+03:00 John Omernik <[email protected]>: > > > Hey all, > > > > I am querying some json and parquet data that has dots in the name. Not > all > > the data I may be querying will come from Drill, thus dot is a valid > > character... when I go to initially explore my data, Drill throws the > error > > below when I run a select * query. > > > > I understand the error, and I can create a view, selecting each column > out > > and renaming it for easier select * in the future. However, as a user, > if > > I get a new data set, this could (unless I am informed of another way > here) > > force me to leave drill to explore my data. > > > > I get how using periods as field qualifiers causes issues... but if we > had > > had a way to read a file to get the schema, to either produce the all the > > fields in a select query for easy view creation or a way to query with > > periods in the name that would be awesome! It would keep users IN drill > > instead of going elsewhere to explore their data. > > > > I am open to ideas! > > > > > > > > > > > > > > > > > > > > > > Error Returned - Code: 500 > > Error Text: > > SYSTEM ERROR: UnsupportedOperationException: Unhandled field reference > > "id.orig_h"; a field reference identifier must not have the form of a > > qualified name (i.e., with "."). > > > > Fragment 0:0 > > > > [Error Id: 88acd3d8-4e44-49f6-b587-24bf26f89a3b on > > zeta4.brewingintel.com:20005] > > >
