question Re: Hive: Query keyword column name in Support Questions

Hive: Query keyword column name

ashsskum — Sun, 13 Nov 2016 06:45:35 GMT

Have an external HIVE table that is based on an avro files and one of the column description is as below. When trying to do SELECT on that with header.timestamp, it fails with the error below. Is there way to query columns with the keywords?

col_name data_type

header struct<versionnum:binary, timestamp:bigint,uuid:binary>

Error:

Error while compiling statement: FAILED: ParseException line 1:80 Failed to recognize predicate 'timestamp'. Failed rule: 'identifier' in expression specification

Re: Hive: Query keyword column name

maheshmsh88 — Mon, 14 Nov 2016 02:24:50 GMT

Hi Kumar,

Please check this https://issues.apache.org/jira/browse/HIVE-10294

Re: Hive: Query keyword column name

myoung — Tue, 15 Nov 2016 04:36:33 GMT

@Kumar

Try using back ticks ` around the column name like `column`.

Re: Hive: Query keyword column name

ashsskum — Sun, 20 Nov 2016 07:55:19 GMT

Thanks,

After doing "set hive.support.sql11.reserved.keywords=false", it allows to query the column with the keyword.

When using back quotes, it gives the following error:

select `header.timestamp` from avro_test_channel;

FAILED: SemanticException [Error 10004]: Line 1:7 Invalid table alias or column reference 'header.timestamp': (possible column names are:

Re: Hive: Query keyword column name

swaranga — Sat, 28 Jan 2017 14:20:57 GMT

For the backtick approach, you might want to try `header`.`timestamp`