hive plan generation

[AnilKumar B]

Hi,

I am trying to generate hive plan as below. But  even after creating the
"src" table, I am facing, Table not found Exception due to MetaStore issue.
Can any one help me in resolving this?


private Driver createDriver() {
HiveConf conf = new HiveConf(Driver.class);
conf.set("hive.metastore.warehouse.dir", "file:///tmp/warehouse");
conf.set("javax.jdo.option.ConnectionURL",
"jdbc:derby:;databaseName=/tmp/metastore_db;create=true");
SessionState.start(conf);
Driver driver = new Driver(conf);
driver.init();
return driver;
}

    Driver driver = createDriver();
driver.compile("create table src (c1 string, c2 string)");
int rc = driver.compile("EXPLAIN LOGICAL SELECT key, count(1) FROM (SELECT
key, value FROM src) subq1 GROUP BY key");

if (rc != 0) {
return;
}

QueryPlan plan = driver.getPlan();
org.apache.hadoop.hive.ql.exec.Task<? extends Serializable> task = plan
.getRootTasks().get(0);
ExplainWork work = (ExplainWork) task.getWork();



Thanks & Regards,
B Anil Kumar.