Reply
Highlighted
New Contributor
Posts: 1
Registered: ‎05-09-2019

Table count in HUE is showing zero, but i see there are parquet files present in the HDFS location.

[ Edited ]

Hi Geeks,

 

Table count in HUE is showing zero, but i see there are parquet files present in the HDFS location.

 

I have checked the logs as well, i see the stats saying that some MB data is laoded with the records count.

 

Kindly need your help in resolving this

 

Thank you!

Posts: 1,903
Kudos: 435
Solutions: 307
Registered: ‎07-31-2013

Re: Table count in HUE is showing zero, but i see there are parquet files present in the HDFS locati

Does the created table carry partition columns? If yes, are the HDFS files in appropriate partition directories and present when you perform a SHOW PARTITIONS query? Can you add the output of 'SHOW CREATE TABLE' for your tablename here?

Also, by "Table count in Hue" do you mean some presented statistics on its UI, or does performing a literal "select count(*) from table;" query result in 0?