hive select count(*) data displaying, but no data visible

Question

I see when I run query select count(*) from table; there's a count of data displaying. but when I check select * from table; there no data been displaying.

can you please help these are external table I went to the location of the tables and I see there's no data present.

"count of data displaying"- 45668, Select * from table; not data diaplying — Santosh, Feb 14 '17 at 22:23
Please see also this: http://stackoverflow.com/a/39914232/2700344 — leftjoin, Feb 15 '17 at 08:52

score 2 · Answer 1 · answered Feb 15 '17 at 05:11

2

run analyze table table_name COMPUTE STATISTICS ; on your table. This will give correct result. As COLUMN_STATS (count) of the table in hive is indexed for fast retrieval. Hence after deleting the underlying data/file , it will give the old stats.

answered Feb 15 '17 at 05:11

Ashish Singh

523
3
14

hive select count(*) data displaying, but no data visible

1 Answers1