Reply
Contributor
Posts: 116
Registered: ‎09-14-2016

Re: Impala select count(*) returns result, but select * return empty

never mind for the timestamp, it is working.

Contributor
Posts: 116
Registered: ‎09-14-2016

Re: Impala select count(*) returns result, but select * return empty

Actually the question should be for avro bytes, what type should i use in HIVE?

Contributor
Posts: 116
Registered: ‎09-14-2016

Re: Impala select count(*) returns result, but select * return empty

I have been trying to use 'binary' or 'decimal' according to HIVE data types for the avro bytes type, but HIVE keeps saying  binary/decimal is not a defined name, any idea?

 

Thanks

Shannon

Cloudera Employee
Posts: 35
Registered: ‎10-20-2015

Re: Impala select count(*) returns result, but select * return empty

https://cwiki.apache.org/confluence/display/Hive/AvroSerDe

 

"Bytes are converted to Array[smallint] prior to Hive 0.12.0."

Contributor
Posts: 116
Registered: ‎09-14-2016

Re: Impala select count(*) returns result, but select * return empty

What version of HIVE from CDH 5.8.2? 

 

i have

 

{"name":"TMS_DATA_ID","type":"Array[smallint]"},

 

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException Encountered exception determining schema. Returning signal schema to indicate problem: Illegal character in: Array[smallint])

 

 

Did i do it worng?

 

 

Highlighted
Cloudera Employee
Posts: 35
Registered: ‎10-20-2015

Re: Impala select count(*) returns result, but select * return empty

You might try asking in a Hive forum

Contributor
Posts: 116
Registered: ‎09-14-2016

Re: Impala select count(*) returns result, but select * return empty

Thanks, i used kafka stream to do a transformation to change the data type and it worked.