1

I have 2 hive table,first table is hive on hbase,second table is a hive table, I insert second table from first table(hive on hbase),but when I run:

select count(*) from table

I got different row number,but when I run:

select * from table

they have same number data, I am so confused about that.

ThanhPhanLe
  • 1,315
  • 3
  • 14
  • 25
liush
  • 13
  • 2
  • This maybe an issue with statistics: https://stackoverflow.com/a/39914232/2700344 – leftjoin Aug 09 '19 at 05:29
  • I set hive.compute.query.using.stats=false but it not working – liush Aug 09 '19 at 06:09
  • You can try also this one: set hive.stats.autogather=true; then recreate table and try again. – F.Lazarescu Aug 09 '19 at 08:32
  • I found Hbase has 100 rows,I run select count(*) from table(hive on hbase) also has 100 rows,but when I run select * from table(hive on hbase) only has 99 rows – liush Aug 12 '19 at 01:32

0 Answers0