You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Golap Binod (JIRA)" <ji...@apache.org> on 2018/10/17 13:01:00 UTC
[jira] [Created] (IMPALA-7719) COMPUTE STATS not working in Impala
2.10.0 on Hive created AVRO Table
Golap Binod created IMPALA-7719:
-----------------------------------
Summary: COMPUTE STATS not working in Impala 2.10.0 on Hive created AVRO Table
Key: IMPALA-7719
URL: https://issues.apache.org/jira/browse/IMPALA-7719
Project: IMPALA
Issue Type: Bug
Components: Backend
Affects Versions: Impala 2.10.0
Environment: Hive version : 1.1.0 , Impala version : 2.10.0,
Linux 2.6.32-504.46.1.el6.x86_64
Reporter: Golap Binod
Hi Team,
I have created Hive Avro table and try to do COMPUTE STATS of that table, but its failed saying "Please re-create the table with column definitions, e.g., using the result of 'SHOW CREATE TABLE'". Tried on SHOW CREATE TABLE, but that also not working. My Hive version : 1.1.0 , Impala version : 2.10.0. Getting below Error:
COMPUTE STATS h011DEMO.CME_CCAR4_SCNR_MGMT_TARGET_VERSIONS
FAILED SSH Client Call: Remote Execution of command returned with '1' exit code and Error message
Starting Impala Shell using Kerberos authentication
Using service name 'impala'
Connected to impala-uat.statestr.com:21000
Server version: impalad version 2.10.0-cdh5.13.1 RELEASE (build 1e4b23c4eb52dac95c5be6316f49685c41783c51)
Query: compute stats h011DEMO.CME_CCAR5_SCNR_MGMT_TARGET_VERSIONS
ERROR: AnalysisException: Cannot COMPUTE STATS on Avro table 'cme_ccar5_scnr_mgmt_target_versions' because its column definitions do not match those in the Avro schema.
Definition of column 'version_id' of type 'double' does not match the Avro-schema column 'row_guid' of type 'STRING' at position '0'.
Please re-create the table with column definitions, e.g., using the result of 'SHOW CREATE TABLE'
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org