[
https://issues.apache.org/jira/browse/IMPALA-7719?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong resolved IMPALA-7719.
-----------------------------------
Resolution: Cannot Reproduce
> 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
> Priority: Major
>
> 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: [email protected]
For additional commands, e-mail: [email protected]
