[ https://issues.apache.org/jira/browse/IMPALA-7719?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16658568#comment-16658568 ]
Tim Armstrong commented on IMPALA-7719: --------------------------------------- [~golapbinod] this seems like it's probably a mismatch between the column schema in the table and the avro schema defined for the table. It's a bit arcane. There is some documentation here: https://impala.apache.org/docs/build/html/topics/impala_avro.html If you feel like there is a bug here, please provide the "show create table" output for the table. > 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: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org