[ 
https://issues.apache.org/jira/browse/KYLIN-4442?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17093734#comment-17093734
 ] 

Sonu Singh commented on KYLIN-4442:
-----------------------------------

Hi [~hit_lacus], 

I have downgrade Hive to 3.1.0 from 3.1.2 and still facing the same issue.

Also when I am trying to execute hive create partition command through hive CLI 
getting below exception :

 

create partition by ALTER TABLE KYLIN.HIVE_METRICS_JOB_QA ADD IF NOT EXISTS 
PARTITION (kday_date='2020-04-27')

NoViableAltException(224@[917:1: ddlStatement : ( createDatabaseStatement | 
switchDatabaseStatement | dropDatabaseStatement | createTableStatement | 
dropTableStatement | truncateTableStatement | alterStatement | descStatement | 
showStatement | metastoreCheck | createViewStatement | 
createMaterializedViewStatement | dropViewStatement | 
dropMaterializedViewStatement | createFunctionStatement | createMacroStatement 
| dropFunctionStatement | reloadFunctionStatement | dropMacroStatement | 
analyzeStatement | lockStatement | unlockStatement | lockDatabase | 
unlockDatabase | createRoleStatement | dropRoleStatement | ( grantPrivileges 
)=> grantPrivileges | ( revokePrivileges )=> revokePrivileges | showGrants | 
showRoleGrants | showRolePrincipals | showRoles | grantRole | revokeRole | 
setRole | showCurrentRole | abortTransactionStatement | killQueryStatement | 
resourcePlanDdlStatements );])
 at org.antlr.runtime.DFA.noViableAlt(DFA.java:158)
 at org.antlr.runtime.DFA.predict(DFA.java:116)
 at 
org.apache.hadoop.hive.ql.parse.HiveParser.ddlStatement(HiveParser.java:4244)
 at 
org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:2494)

 

> Kylin System Cube Hive tables not able to update 
> -------------------------------------------------
>
>                 Key: KYLIN-4442
>                 URL: https://issues.apache.org/jira/browse/KYLIN-4442
>             Project: Kylin
>          Issue Type: Bug
>    Affects Versions: v3.0.0
>            Reporter: Sonu Singh
>            Priority: Blocker
>         Attachments: image-2020-04-18-17-26-33-316.png, 
> kylin-metrics-reporter-hive-3.1.0-SNAPSHOT.jar
>
>
> Kylin System Cube Hive table is not updating. I am using Kylin hadoop3 code 
> and running on vanilla hadoop3.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to