Skip to content

Instantly share code, notes, and snippets.

@shun0102
Created March 16, 2016 05:16
Show Gist options
  • Save shun0102/926a802e96e914f4ea41 to your computer and use it in GitHub Desktop.
Save shun0102/926a802e96e914f4ea41 to your computer and use it in GitHub Desktop.
2016-03-16 12:52:36.622 +0900: Embulk v0.8.7
2016-03-16 12:52:42.721 +0900 [INFO] (0001:transaction): Loaded plugin embulk-input-mysql (0.6.4)
2016-03-16 12:52:42.837 +0900 [INFO] (0001:transaction): Loaded plugin embulk-output-jdbc (0.5.0)
2016-03-16 12:52:43.020 +0900 [INFO] (0001:transaction): Fetch size is 10000. Using server-side prepared statement.
2016-03-16 12:52:43.648 +0900 [INFO] (0001:transaction): SQL: SELECT
2016-03-16 12:52:43.936 +0900 [INFO] (0001:transaction): Using local thread executor with max_threads=2 / tasks=1
2016-03-16 12:52:44.041 +0900 [INFO] (0001:transaction): Connecting to jdbc:hive2://had01:10000;AuthMech=2;UID=hive options {}
2016-03-16 12:52:45.333 +0900 [INFO] (0001:transaction): Using insert mode
2016-03-16 12:52:45.881 +0900 [INFO] (0001:transaction): SQL: DROP TABLE IF EXISTS `table_d88a19cf0e40_bl_tmp000`
2016-03-16 12:52:46.045 +0900 [INFO] (0001:transaction): > 0.16 seconds (-1 rows)
2016-03-16 12:52:46.050 +0900 [INFO] (0001:transaction): SQL: CREATE TABLE IF NOT EXISTS `table_d88a19cf0e40_bl_tmp000` ()
2016-03-16 12:52:46.103 +0900 [INFO] (0001:transaction): > 0.05 seconds (-1 rows)
2016-03-16 12:52:46.289 +0900 [INFO] (0001:transaction): {done: 0 / 1, running: 0}
2016-03-16 12:52:46.552 +0900 [INFO] (0017:task-0000): Connecting to jdbc:hive2://had01:10000;AuthMech=2;UID=hive options {}
2016-03-16 12:52:46.867 +0900 [INFO] (0017:task-0000): Prepared SQL: INSERT INTO `table_d88a19cf0e40_bl_tmp000` () VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2016-03-16 12:52:47.619 +0900 [INFO] (0017:task-0000): Fetch size is 10000. Using server-side prepared statement.
2016-03-16 12:52:47.648 +0900 [INFO] (0017:task-0000): SQL: SELECT
2016-03-16 12:52:47.706 +0900 [INFO] (0017:task-0000): > 0.05 seconds
2016-03-16 12:52:48.279 +0900 [INFO] (0017:task-0000): Fetched 500 rows.
2016-03-16 12:52:48.375 +0900 [INFO] (0017:task-0000): Fetched 1,000 rows.
2016-03-16 12:52:48.504 +0900 [INFO] (0017:task-0000): Fetched 2,000 rows.
2016-03-16 12:52:49.016 +0900 [INFO] (0017:task-0000): Fetched 4,000 rows.
2016-03-16 12:52:49.362 +0900 [INFO] (0017:task-0000): Fetched 8,000 rows.
2016-03-16 12:52:49.704 +0900 [INFO] (0017:task-0000): Loading 10,000 rows
2016-03-16 12:52:53.403 +0900 [INFO] (0001:transaction): {done: 1 / 1, running: 0}
2016-03-16 12:52:53.456 +0900 [INFO] (0001:cleanup): Connecting to jdbc:hive2://had01:10000;AuthMech=2;UID=hive options {}
2016-03-16 12:52:53.900 +0900 [INFO] (0001:cleanup): SQL: DROP TABLE IF EXISTS `table_d88a19cf0e40_bl_tmp000`
2016-03-16 12:52:53.976 +0900 [INFO] (0001:cleanup): > 0.07 seconds (-1 rows)
org.embulk.exec.PartialExecutionException: java.lang.RuntimeException: java.sql.SQLException: [Cloudera][HiveJDBCDriver](500051) ERROR processing query/statement.
Error Code: 10293, SQL state: TStatus(statusCode:ERROR_STATUS, infoMessages:[*org.apache.hive.service.cli.HiveSQLException:Error while compiling statement:
FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values Expression of type TOK_FUNCTION not supported in insert/values:28:27,
org.apache.hive.service.cli.operation.Operation:toSQLException:Operation.java:326,
org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:102,
org.apache.hive.service.cli.operation.SQLOperation:runInternal:SQLOperation.java:171,
org.apache.hive.service.cli.operation.Operation:run:Operation.java:268,
org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementInternal:HiveSessionImpl.java:410,
org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementAsync:HiveSessionImpl.java:397,
sun.reflect.GeneratedMethodAccessor362:invoke::-1, sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43,
java.lang.reflect.Method:invoke:Method.java:483,
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:1671,
org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:59, com.sun.proxy.$Proxy21:executeStatementAsync::-1,
org.apache.hive.service.cli.CLIService:executeStatementAsync:CLIService.java:258,
org.apache.hive.service.cli.thrift.ThriftCLIService:ExecuteStatement:ThriftCLIService.java:509,
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:1142,
java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:617,
java.lang.Thread:run:Thread.java:745,
*org.apache.hadoop.hive.ql.parse.SemanticException:Unable to create temp file for insert values Expression of type TOK_FUNCTION not supported in insert/values:38:11,
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genValuesTempTable:SemanticAnalyzer.java:831,
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:doPhase1:SemanticAnalyzer.java:1224,
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:doPhase1:SemanticAnalyzer.java:1427,
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genResolvedParseTree:SemanticAnalyzer.java:10198,
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:analyzeInternal:SemanticAnalyzer.java:10256,
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:analyzeInternal:SemanticAnalyzer.java:10141,
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer:analyze:BaseSemanticAnalyzer.java:222,
org.apache.hadoop.hive.ql.Driver:compile:Driver.java:421,
org.apache.hadoop.hive.ql.Driver:compile:Driver.java:305,
org.apache.hadoop.hive.ql.Driver:compileInternal:Driver.java:1110,
org.apache.hadoop.hive.ql.Driver:compileAndRespond:Driver.java:1104,
org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:100,
*org.apache.hadoop.hive.ql.parse.SemanticException:Expression of type TOK_FUNCTION not supported in insert/values:39:1,
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:unparseExprForValuesClause:SemanticAnalyzer.java:875,
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genValuesTempTable:SemanticAnalyzer.java:803],
sqlState:42000, errorCode:10293, errorMessage:Error while compiling statement: FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values Expression of type TOK_FUNCTION not supported in insert/values),
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment