https://community.cloudera.com/t5/Support-Questions/COMPUTE-Stats-or-Analyze-table/m-p/89296#M11997 <P>Hi All,</P><P>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.</P><P>Tables are not partitioned and the files are in text/csv format.</P><P>How should we collect stats using Impala or Hive ?</P><P>Is it possible to collect stats for Hive tables using Impala and HIve tables stats should only be created to hive. Appreciate your help.</P><P>&nbsp;</P><P>Regards.</P><P>Sandeep Suman</P> Fri, 16 Sep 2022 14:19:21 GMT ispirit 2022-09-16T14:19:21Z https://community.cloudera.com/t5/Support-Questions/COMPUTE-Stats-or-Analyze-table/m-p/89296#M11997 <P>Hi All,</P><P>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.</P><P>Tables are not partitioned and the files are in text/csv format.</P><P>How should we collect stats using Impala or Hive ?</P><P>Is it possible to collect stats for Hive tables using Impala and HIve tables stats should only be created to hive. Appreciate your help.</P><P>&nbsp;</P><P>Regards.</P><P>Sandeep Suman</P> Fri, 16 Sep 2022 14:19:21 GMT https://community.cloudera.com/t5/Support-Questions/COMPUTE-Stats-or-Analyze-table/m-p/89296#M11997 ispirit 2022-09-16T14:19:21Z https://community.cloudera.com/t5/Support-Questions/COMPUTE-Stats-or-Analyze-table/m-p/89318#M11998 <P>If you are mainly accessing the table using Impala, I'd recommend Impala's compute stats for best performance of Impala.</P><P>&nbsp;</P><P>There are some subtle differences in the stats collected (whether they're partition or table-level). The engines can interoperate but Impala can generally generate better plans with the full set of stats from "COMPUTE STATS"</P> Thu, 18 Apr 2019 17:09:14 GMT https://community.cloudera.com/t5/Support-Questions/COMPUTE-Stats-or-Analyze-table/m-p/89318#M11998 Tim Armstrong 2019-04-18T17:09:14Z