Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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

Contributor

never mind for the timestamp, it is working.

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

Contributor

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

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

Contributor

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

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

Contributor

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

 

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

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

Contributor

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

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

Contributor

You might try asking in a Hive forum

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

Contributor

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