connect apache hive with superset issues

Question

we make database connect to apache hive and it's 'ok ,

Screenshot 2024-02-06 160002.png

but , the following issues when try to browse tables when we try to create dataset

Screenshot 2024-02-06 160145.png

2024-02-06 09:58:58,682:DEBUG:pyhive.hive:TExecuteStatementReq(sessionHandle=TSessionHandle(sessionId=THandleIdentifier(guid=b'\x9d\xfc\x17\xd3acJ\x81\x87\xf2<\x92mk\x92C', secret=b'\x1b\x8f\x9cX_NIP\x96\xe55\xce\x16\x0e\xf1:')), statement='SHOW VIEWS IN hrdb', confOverlay=None, runAsync=False, queryTimeout=0)

12024-02-06 09:58:58,688:DEBUG:pyhive.hive:TExecuteStatementResp(status=TStatus(statusCode=3, infoMessages=["*org.apache.hive.service.cli.HiveSQLException:Error while compiling statement: FAILED: ParseException line 1:5 cannot recognize input near 'SHOW' 'VIEWS' 'IN' in ddl statement:28:27", 'org.apache.hive.service.cli.operation.Operation:toSQLException:Operation.java:374', 'org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:136', 'org.apache.hive.service.cli.operation.SQLOperation:runInternal:SQLOperation.java:206', 'org.apache.hive.service.cli.operation.Operation:run:Operation.java:316', 'org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementInternal:HiveSessionImpl.java:425', 'org.apache.hive.service.cli.session.HiveSessionImpl:executeStatement:HiveSessionImpl.java:395', 'sun.reflect.GeneratedMethodAccessor49:invoke::-1', 'sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43', 'java.lang.reflect.Method:invoke:Method.java:606', 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:78', 'org.apache.hive.service.cli.session.HiveSessionProxy:access$000:HiveSessionProxy.java:36', 'org.apache.hive.service.cli.session.HiveSessionProxy$1:run:HiveSessionProxy.java:63', 'java.security.AccessController:doPrivileged:AccessController.java:-2', 'javax.security.auth.Subject:doAs:Subject.java:415', 'org.apache.hadoop.security.UserGroupInformation:doAs:UserGroupInformation.java:1693', 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:59', 'com.sun.proxy.$Proxy23:executeStatement::-1', 'org.apache.hive.service.cli.CLIService:executeStatement:CLIService.java:245', 'org.apache.hive.service.cli.thrift.ThriftCLIService:ExecuteStatement:ThriftCLIService.java:506', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1313', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1298', 'org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39', 'org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39', 'org.apache.hive.service.auth.TSetIpAddressProcessor:process:TSetIpAddressProcessor.java:56', 'org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:285', 'java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1145', 'java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:615', 'java.lang.Thread:run:Thread.java:745', "*org.apache.hadoop.hive.ql.parse.ParseException:line 1:5 cannot recognize input near 'SHOW' 'VIEWS' 'IN' in ddl statement:33:6", 'org.apache.hadoop.hive.ql.parse.ParseDriver:parse:ParseDriver.java:204', 'org.apache.hadoop.hive.ql.parse.ParseDriver:parse:ParseDriver.java:166', 'org.apache.hadoop.hive.ql.Driver:compile:Driver.java:423', 'org.apache.hadoop.hive.ql.Driver:compile:Driver.java:311', 'org.apache.hadoop.hive.ql.Driver:compileInternal:Driver.java:1194', 'org.apache.hadoop.hive.ql.Driver:compileAndRespond:Driver.java:1181', 'org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:134'], sqlState='42000', errorCode=40000, errorMessage="Error while compiling statement: FAILED: ParseException line 1:5 cannot recognize input near 'SHOW' 'VIEWS' 'IN' in ddl statement"), operationHandle=None)
2024-02-06 09:58:58,697:DEBUG:pyhive.hive:TCloseSessionResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None))
134.136.145.140 - - [06/Feb/2024:09:58:58 +0000] "GET /api/v1/database/3/tables/?q=(force:!f,schema_name:hrdb) HTTP/1.1" 422 76 "http://10.250.112.95:8088/dataset/add/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36"

ggangadharan · Accepted Answer

The error you're encountering indicates that there's an issue with the syntax of your DDL (Data Definition Language) statement, specifically related to the SHOW VIEWS IN clause.

Error while compiling statement: FAILED: ParseException line 1:5 cannot recognize input near 'SHOW' 'VIEWS' 'IN' in ddl statement

If you are trying to show the views in a particular database, the correct syntax would be:

SHOW VIEWS IN your_database_name;

Replace your_database_name with the actual name of the database you want to query. Ensure that there are no typos or extraneous characters in the statement.

If you are not using a specific database and want to see all views in the current database, you can use:

SHOW VIEWS;

Double-check your SQL statement for correctness and make sure it adheres to the syntax rules of the database you are working with.

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.