Hi All, We have created a Hive database and have some external tables on with files placed in S3 bucket. Our Application accesses this data using Impala. Tables are not partitioned and the files are in text/csv format. How should we collect stats using Impala or Hive ? Is it possible to collect stats for Hive tables using Impala and HIve tables stats should only be created to hive. Appreciate your help.   Regards. Sandeep Suman ... View more

Hi All,   We have sqooped data from MS-SQL 2008 into HDFS and created external tables . The record count shows same between the MS-SQL table and Hive tables. However, if i fire same query on MS-SQL table and Hive table, the output is different. The query is being fired through Hue(tested through Impala as well). Could you please help, if i missed something?   Regards. Sandeep Suman ... View more