API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 16th, 2016
79
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.92 KB | None | 0 0
raw download clone embed print report
  1. 2016-03-16 12:52:36.622 +0900: Embulk v0.8.7
  2. 2016-03-16 12:52:42.721 +0900 [INFO] (0001:transaction): Loaded plugin embulk-input-mysql (0.6.4)
  3. 2016-03-16 12:52:42.837 +0900 [INFO] (0001:transaction): Loaded plugin embulk-output-jdbc (0.5.0)
  4. 2016-03-16 12:52:43.020 +0900 [INFO] (0001:transaction): Fetch size is 10000. Using server-side prepared statement.
  5. 2016-03-16 12:52:43.648 +0900 [INFO] (0001:transaction): SQL: SELECT
  6. 2016-03-16 12:52:43.936 +0900 [INFO] (0001:transaction): Using local thread executor with max_threads=2 / tasks=1
  7. 2016-03-16 12:52:44.041 +0900 [INFO] (0001:transaction): Connecting to jdbc:hive2://had01:10000;AuthMech=2;UID=hive options {}
  8. 2016-03-16 12:52:45.333 +0900 [INFO] (0001:transaction): Using insert mode
  9. 2016-03-16 12:52:45.881 +0900 [INFO] (0001:transaction): SQL: DROP TABLE IF EXISTS `table_d88a19cf0e40_bl_tmp000`
  10. 2016-03-16 12:52:46.045 +0900 [INFO] (0001:transaction): > 0.16 seconds (-1 rows)
  11. 2016-03-16 12:52:46.050 +0900 [INFO] (0001:transaction): SQL: CREATE TABLE IF NOT EXISTS `table_d88a19cf0e40_bl_tmp000` ()
  12. 2016-03-16 12:52:46.103 +0900 [INFO] (0001:transaction): > 0.05 seconds (-1 rows)
  13. 2016-03-16 12:52:46.289 +0900 [INFO] (0001:transaction): {done: 0 / 1, running: 0}
  14. 2016-03-16 12:52:46.552 +0900 [INFO] (0017:task-0000): Connecting to jdbc:hive2://had01:10000;AuthMech=2;UID=hive options {}
  15. 2016-03-16 12:52:46.867 +0900 [INFO] (0017:task-0000): Prepared SQL: INSERT INTO `table_d88a19cf0e40_bl_tmp000` () VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  16. 2016-03-16 12:52:47.619 +0900 [INFO] (0017:task-0000): Fetch size is 10000. Using server-side prepared statement.
  17. 2016-03-16 12:52:47.648 +0900 [INFO] (0017:task-0000): SQL: SELECT
  18. 2016-03-16 12:52:47.706 +0900 [INFO] (0017:task-0000): > 0.05 seconds
  19. 2016-03-16 12:52:48.279 +0900 [INFO] (0017:task-0000): Fetched 500 rows.
  20. 2016-03-16 12:52:48.375 +0900 [INFO] (0017:task-0000): Fetched 1,000 rows.
  21. 2016-03-16 12:52:48.504 +0900 [INFO] (0017:task-0000): Fetched 2,000 rows.
  22. 2016-03-16 12:52:49.016 +0900 [INFO] (0017:task-0000): Fetched 4,000 rows.
  23. 2016-03-16 12:52:49.362 +0900 [INFO] (0017:task-0000): Fetched 8,000 rows.
  24. 2016-03-16 12:52:49.704 +0900 [INFO] (0017:task-0000): Loading 10,000 rows
  25. 2016-03-16 12:52:53.403 +0900 [INFO] (0001:transaction): {done: 1 / 1, running: 0}
  26. 2016-03-16 12:52:53.456 +0900 [INFO] (0001:cleanup): Connecting to jdbc:hive2://had01:10000;AuthMech=2;UID=hive options {}
  27. 2016-03-16 12:52:53.900 +0900 [INFO] (0001:cleanup): SQL: DROP TABLE IF EXISTS `table_d88a19cf0e40_bl_tmp000`
  28. 2016-03-16 12:52:53.976 +0900 [INFO] (0001:cleanup): > 0.07 seconds (-1 rows)
  29. org.embulk.exec.PartialExecutionException: java.lang.RuntimeException: java.sql.SQLException: [Cloudera][HiveJDBCDriver](500051) ERROR processing query/statement.
  30. Error Code: 10293, SQL state: TStatus(statusCode:ERROR_STATUS, infoMessages:[*org.apache.hive.service.cli.HiveSQLException:Error while compiling statement:
  31. FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values Expression of type TOK_FUNCTION not supported in insert/values:28:27,
  32. org.apache.hive.service.cli.operation.Operation:toSQLException:Operation.java:326,
  33. org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:102,
  34. org.apache.hive.service.cli.operation.SQLOperation:runInternal:SQLOperation.java:171,
  35. org.apache.hive.service.cli.operation.Operation:run:Operation.java:268,
  36. org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementInternal:HiveSessionImpl.java:410,
  37. org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementAsync:HiveSessionImpl.java:397,
  38. sun.reflect.GeneratedMethodAccessor362:invoke::-1, sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43,
  39. java.lang.reflect.Method:invoke:Method.java:483,
  40. org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:78,
  41. org.apache.hive.service.cli.session.HiveSessionProxy:access$000:HiveSessionProxy.java:36,
  42. org.apache.hive.service.cli.session.HiveSessionProxy$1:run:HiveSessionProxy.java:63,
  43. java.security.AccessController:doPrivileged:AccessController.java:-2, javax.security.auth.Subject:doAs:Subject.java:422,
  44. org.apache.hadoop.security.UserGroupInformation:doAs:UserGroupInformation.java:1671,
  45. org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:59, com.sun.proxy.$Proxy21:executeStatementAsync::-1,
  46. org.apache.hive.service.cli.CLIService:executeStatementAsync:CLIService.java:258,
  47. org.apache.hive.service.cli.thrift.ThriftCLIService:ExecuteStatement:ThriftCLIService.java:509,
  48. org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1313,
  49. org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1298,
  50. org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39,
  51. org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39,
  52. org.apache.hive.service.auth.TSetIpAddressProcessor:process:TSetIpAddressProcessor.java:56,
  53. org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:285,
  54. java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1142,
  55. java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:617,
  56. java.lang.Thread:run:Thread.java:745,
  57. *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,
  58. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genValuesTempTable:SemanticAnalyzer.java:831,
  59. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:doPhase1:SemanticAnalyzer.java:1224,
  60. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:doPhase1:SemanticAnalyzer.java:1427,
  61. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genResolvedParseTree:SemanticAnalyzer.java:10198,
  62. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:analyzeInternal:SemanticAnalyzer.java:10256,
  63. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:analyzeInternal:SemanticAnalyzer.java:10141,
  64. org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer:analyze:BaseSemanticAnalyzer.java:222,
  65. org.apache.hadoop.hive.ql.Driver:compile:Driver.java:421,
  66. org.apache.hadoop.hive.ql.Driver:compile:Driver.java:305,
  67. org.apache.hadoop.hive.ql.Driver:compileInternal:Driver.java:1110,
  68. org.apache.hadoop.hive.ql.Driver:compileAndRespond:Driver.java:1104,
  69. org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:100,
  70. *org.apache.hadoop.hive.ql.parse.SemanticException:Expression of type TOK_FUNCTION not supported in insert/values:39:1,
  71. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:unparseExprForValuesClause:SemanticAnalyzer.java:875,
  72. org.apache.hadoop.hive.ql.parse.SemanticAnalyzer:genValuesTempTable:SemanticAnalyzer.java:803],
  73. 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),
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!