Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

COMPUTE Stats or Analyze table

Solved Go to solution
Highlighted

COMPUTE Stats or Analyze table

New Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: COMPUTE Stats or Analyze table

Master Collaborator

If you are mainly accessing the table using Impala, I'd recommend Impala's compute stats for best performance of Impala.

 

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"

1 REPLY 1

Re: COMPUTE Stats or Analyze table

Master Collaborator

If you are mainly accessing the table using Impala, I'd recommend Impala's compute stats for best performance of Impala.

 

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"

Don't have an account?
Coming from Hortonworks? Activate your account here