Version: 16.0.0-dev-70
Build #: 41452
Build Date: 2014-Dec-11 10:49:43 AM
Operating Environment: Mac OS X (10.8.5, x86_64) / UTF-8 / en / US / Oracle Corporation 1.7.0_60-b19
Memory: Max=3,819,962,368; Total=978,845,696; Free=555,358,448; CPUs=8
HortonWorks 2.2 : Automate-> Introduce INSERT Statement gives exception
1. Open a new query Window to HortonWorks 2.2
2. Go to Automate-> Introduce Insert Statement and select it
You get below exception in error log:
org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10001]: Table not found TABLE
at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:233)
at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:219)
at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:254)
at org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:392)
at com.aquafold.aquacore.open.rdbms.drivers.hive.zᡱꍂ⡛ꂸ instanceof finally.executeQuery(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Hꁍꃰꐱ⣋ 6.executeQuery(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.e⢯⢭ꆗ̴ throw goto.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.e⢯⢭ꆗ̴ throw goto.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.e⢯⢭ꆗ̴ throw goto.b(Unknown Source)
at com.aquafold.aquaeditor.sql.SQLStdCompletionQuery.queryCompletionOnType(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Jꁕꉰꂉꎱ assert native.query(Unknown Source)
at org.netbeans.spi.editor.completion.support.AsyncCompletionTask.run(AsyncCompletionTask.java:223)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1411)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:1991)
Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10001]: Table not found TABLE
at org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:314)
at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:102)
at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:171)
at org.apache.hive.service.cli.operation.Operation.run(Operation.java:256)
at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:377)
at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:364)
at org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:247)
at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:396)
at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1313)
at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1298)
at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:206)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.hadoop.hive.ql.parse.SemanticException: Table not found TABLE
at org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer$QualifiedNameUtil.getTableName(DDLSemanticAnalyzer.java:1829)
at org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeDescribeTable(DDLSemanticAnalyzer.java:1979)
at org.apache.hadoop.hive.ql.parse.DDLSemanticAnalyzer.analyzeInternal(DDLSemanticAnalyzer.java:331)
at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:221)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:415)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:303)
at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1067)
at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1061)
at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:100)
... 15 more
Also added in V15 - ADS 15.0.11-7