[ https://issues.apache.org/jira/browse/HIVE-26345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
zhangbutao updated HIVE-26345: ------------------------------ Description: Beeline client may can not get real exception from _*SQLOperation class*_ and user may don't how to fix query based on client exception massage. Step to repro: {code:java} set hive.support.concurrency=false; set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; create table testacid(id int) stored as orc tblproperties('transactional'='true');{code} Beeline console output exception: {code:java} Error: Error running query (state=,code=0) {code} However, Hive3 beeline can output readable exception information: {code:java} Error: Error while compiling statement: FAILED: RuntimeException [Error 10264]: To use DbTxnManager you must set hive.support.concurrency=true (state=42000,code=10264) {code} This change was introduced by HIVE-23124, i think we should fix this to output real exception to prompt users to amend the query. was: Beeline client may can not get real exception from _*SQLOperation class*_ and user may don't how to fix query based on client exception massage. Step to repro: {code:java} set hive.support.concurrency=false; set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; create table testacid(id int) stored as orc tblproperties('transactional'='true');{code} Beeline console output exception: {code:java} Error: Error running query (state=,code=0) {code} However, Hive3 beeline can output readable exception information: {code:java} Error: Error while compiling statement: FAILED: RuntimeException [Error 10264]: To use DbTxnManager you must set hive.support.concurrency=true (state=42000,code=10264) {code} This change was introduced by HIVE-23124, i think we should fix this to output real exception to prompt users to amend the query. > SQLOperation class output real exception message to jdbc client > --------------------------------------------------------------- > > Key: HIVE-26345 > URL: https://issues.apache.org/jira/browse/HIVE-26345 > Project: Hive > Issue Type: Improvement > Components: HiveServer2 > Affects Versions: 4.0.0-alpha-2 > Reporter: zhangbutao > Assignee: zhangbutao > Priority: Major > > Beeline client may can not get real exception from _*SQLOperation class*_ and > user may don't how to fix query based on client exception massage. > Step to repro: > {code:java} > set hive.support.concurrency=false; > set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; > create table testacid(id int) stored as orc > tblproperties('transactional'='true');{code} > Beeline console output exception: > {code:java} > Error: Error running query (state=,code=0) {code} > > However, Hive3 beeline can output readable exception information: > {code:java} > Error: Error while compiling statement: FAILED: RuntimeException [Error > 10264]: To use DbTxnManager you must set hive.support.concurrency=true > (state=42000,code=10264) {code} > > This change was introduced by HIVE-23124, i think we should fix this to > output real exception to prompt users to amend the query. -- This message was sent by Atlassian Jira (v8.20.7#820007)