pranavoyo opened a new issue #4327: Getting error, "Error while compiling statement: FAILED: ParseException line 3:10 mismatched input 'NOT' expecting ) near 'INT' in create table statement URL: https://github.com/apache/incubator-superset/issues/4327 Make sure these boxes are checked before submitting your issue - thank you! - [ ] I have checked the superset logs for python stacktraces and included it here as text if any - [ ] I have reproduced the issue with at least the latest released version of superset - [ ] I have checked the issue tracker for the same issue and I haven't found one similar ### Superset version ### Expected results command should work without any error ### Actual results 2018-02-02 06:40:58,016:DEBUG:pyhive.hive:TExecuteStatementResp(status=TStatus(errorCode=10001, errorMessage=u'Error while compiling statement: FAILED: SemanticException [Error 10001]: Table not found ab_user_role', sqlState=u'42S02', infoMessages=[u'*org.apache.hive.service.cli.HiveSQLException:Error while compiling statement: FAILED: SemanticException [Error 10001]: Table not found ab_user_role:28:27', u'org.apache.hive.service.cli.operation.Operation:toSQLException:Operation.java:388', u'org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:193', u'org.apache.hive.service.cli.operation.SQLOperation:runInternal:SQLOperation.java:276', u'org.apache.hive.service.cli.operation.Operation:run:Operation.java:324', u'org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementInternal:HiveSessionImpl.java:499', u'org.apache.hive.service.cli.session.HiveSessionImpl:executeStatement:HiveSessionImpl.java:475', u'sun.reflect.GeneratedMethodAccessor73:invoke::-1', u'sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43', u'java.lang.reflect.Method:invoke:Method.java:498', u'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:78', u'org.apache.hive.service.cli.session.HiveSessionProxy:access$000:HiveSessionProxy.java:36', u'org.apache.hive.service.cli.session.HiveSessionProxy$1:run:HiveSessionProxy.java:63', u'java.security.AccessController:doPrivileged:AccessController.java:-2', u'javax.security.auth.Subject:doAs:Subject.java:422', u'org.apache.hadoop.security.UserGroupInformation:doAs:UserGroupInformation.java:1698', u'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:59', u'com.sun.proxy.$Proxy35:executeStatement::-1', u'org.apache.hive.service.cli.CLIService:executeStatement:CLIService.java:270', u'org.apache.hive.service.cli.thrift.ThriftCLIService:ExecuteStatement:ThriftCLIService.java:507', u'org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1437', u'org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1422', u'org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39', u'org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39', u'org.apache.hive.service.auth.TSetIpAddressProcessor:process:TSetIpAddressProcessor.java:56', u'org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:286', u'java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1142', u'java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:617', u'java.lang.Thread:run:Thread.java:745', u'*org.apache.hadoop.hive.ql.parse.SemanticException:Table not found ab_user_role:35:8', u'org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer:getTable:BaseSemanticAnalyzer.java:1673', u'org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer:getTable:BaseSemanticAnalyzer.java:1652', u'org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer:analyzeDescribeTable:DDLSemanticAnalyzer.java:2043', u'org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer:analyzeInternal:DDLSemanticAnalyzer.java:348', u'org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer:analyze:BaseSemanticAnalyzer.java:250', u'org.apache.hadoop.hive.ql.Driver:compile:Driver.java:477', u'org.apache.hadoop.hive.ql.Driver:compileInternal:Driver.java:1242', u'org.apache.hadoop.hive.ql.Driver:compileAndRespond:Driver.java:1229', u'org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:191'], statusCode=3), operationHandle=None) ### Steps to reproduce On setting up hive url in sqlalchemy connection; then running any superset command. SQLALCHEMY_DATABASE_URI = 'hive://localhost:10000/default'
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
