Why are you trying to create a table to? > 'hdfs://localhost:8020/user/hive/warehouse/OOZIE_TEST'
I your in a pseudo distributed test mode? On Wed, Jun 27, 2012 at 3:27 PM, vijaya bhaskar peddinti <[email protected]> wrote: > Hi All, > > I have installed Oozie 3.2 with Hadoop 0.20.2 and Hive 0.7.0. I am able > to run the Hive Action example provided with the distribution of Oozie 3.2. > But i when a create HIve Script (query in script.q) which tries to access > existing tables( tables created from Hive Cli) oozie workflow is failing > and the exception is as given below. Any pointers/suggestions in resolving > this issue would of great help. > > Similarly i am also not able to access from HIVE CLI, tables which are > created by Oozie Hive Action(query in script.q). > > Few observations that i could make are: > 1. In HiveMetastore i could see 2 tables: COLUMNS and COLUMNS_V2(i am not > sure whether it should be like that or not) > 2. Column Info for Tables created through Hive Cli are present in COLUMNS > and Columns info created through Oozie hive action are in Columns_V2. > > Thanks and regards, > Vijaya Bhaskar Peddinti > > OOZIE SHARED LIB: > It contains libs of Hive 0.9.0 jars. > > SCRIPT: > INSERT OVERWRITE DIRECTORY > 'hdfs://localhost:8020/user/hive/warehouse/OOZIE_TEST' SELECT * from users; > --users is the table created previously from Hive CLIs. Similarly i am also > not able to access the Oozie Hive Action through created tables from Hive > CLI > > ERROR LOG: > Logging initialized using configuration in > jar:file:/var/lib/hadoop-0.20/cache/mapred/mapred/local/taskTracker/distcache/3564603556435604606_1807580103_769748789/localhost/user/root/share/lib/hive/hive-common-0.9.0.jar!/hive-log4j.properties > Hive history file=/tmp/mapred/hive_job_log_mapred_201206270520_15838734.txt > FAILED: Hive Internal Error: java.lang.NullPointerException(null) > java.lang.NullPointerException > at org.apache.hadoop.hive.ql.metadata.Table.checkValidity(Table.java:162) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:929) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:830) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:954) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:7524) > at > org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:243) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:431) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:336) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:909) > at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:258) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:215) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:406) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:341) > at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:439) > at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:449) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:647) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:557) > at org.apache.oozie.action.hadoop.HiveMain.runHive(HiveMain.java:303) > at org.apache.oozie.action.hadoop.HiveMain.run(HiveMain.java:280) > at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:37) > at org.apache.oozie.action.hadoop.HiveMain.main(HiveMain.java:55) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.apache.oozie.action.hadoop.LauncherMapper.map(LauncherMapper.java:467) > at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50) > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:390) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:324) > at org.apache.hadoop.mapred.Child$4.run(Child.java:268) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:396) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1115) > at org.apache.hadoop.mapred.Child.main(Child.java:262) > Intercepting System.exit(12) > Failing Oozie Launcher, Main class > [org.apache.oozie.action.hadoop.HiveMain], exit code [12]
