python - 使用pyhive 能夠執行source 語句嗎
問題描述
cursor.execute('source ’/home/hadoop/create_table.sql’')執行結果
OperationalError: TExecuteStatementResp(status=TStatus(infoMessages=['*org.apache.hive.service.cli.HiveSQLException:Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near ’source’ ’/’ ’home’:28:27', ’org.apache.hive.service.cli.operation.Operation:toSQLException:Operation.java:388’, ’org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:193’, ’org.apache.hive.service.cli.operation.SQLOperation:runInternal:SQLOperation.java:276’, ’org.apache.hive.service.cli.operation.Operation:run:Operation.java:324’, ’org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementInternal:HiveSessionImpl.java:499’, ’org.apache.hive.service.cli.session.HiveSessionImpl:executeStatement:HiveSessionImpl.java:475’, ’sun.reflect.GeneratedMethodAccessor10:invoke::-1’, ’sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43’, ’java.lang.reflect.Method:invoke:Method.java:498’, ’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:422’, ’org.apache.hadoop.security.UserGroupInformation:doAs:UserGroupInformation.java:1548’, ’org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:59’, ’com.sun.proxy.$Proxy34:executeStatement::-1’, ’org.apache.hive.service.cli.CLIService:executeStatement:CLIService.java:270’, ’org.apache.hive.service.cli.thrift.ThriftCLIService:ExecuteStatement:ThriftCLIService.java:507’, ’org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1437’, ’org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1422’, ’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:286’, ’java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1142’, ’java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:617’, ’java.lang.Thread:run:Thread.java:748’, '*org.apache.hadoop.hive.ql.parse.ParseException:line 1:0 cannot recognize input near ’source’ ’/’ ’home’:32:5', ’org.apache.hadoop.hive.ql.parse.ParseDriver:parse:ParseDriver.java:207’, ’org.apache.hadoop.hive.ql.parse.ParseDriver:parse:ParseDriver.java:166’, ’org.apache.hadoop.hive.ql.Driver:compile:Driver.java:444’, ’org.apache.hadoop.hive.ql.Driver:compileInternal:Driver.java:1242’, ’org.apache.hadoop.hive.ql.Driver:compileAndRespond:Driver.java:1229’, ’org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:191’], statusCode=3, sqlState=’42000’, errorMessage='Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near ’source’ ’/’ ’home’', errorCode=40000), operationHandle=None)
以上報錯
問題解答
回答1：source /home/hadoop/create_table.sql
相關文章：
1. javascript - vue提示語法錯誤，請問錯誤在哪？2. css - 移動端 oppo 手機之 Border-radius3. 淺談vue生命周期共有幾個階段？分別是什么？4. index.php錯誤，求指點5. java - web端百度網盤的一個操作為什么要分兩次請求服務器, 有什么好處嗎6. javascript - vue.js如何遞歸渲染組件.7. python - 抓包只抓到json，真實的地址卻找不到8. javascript - 為什么我的animation-fill-mode 設置不生效9. angular.js - angularjs中添加高德地圖API，地圖顯示不正常，控制臺報錯，何解？10. html - JavaScript的Dom操作如何改變子元素的文本內容
網公網安備