Create View in Hivesterix

[Pushkar Khadilkar]

Hi,

We are using Hivesterix as a front end to submit queries to Hyracks.

Hive supports create view statement. Does Hivesterix support create view statement ?

I could not find any explicit mention on wiki.

I ran a few TPCH queries modified to use create view statements (some of which ran correctly).

I would highly appreciate if someone from Hivesterix development team could clarify.

We are working on an implementation that would benefit from ability to use views in Hivesterix.

If not, we will need to change our approach.

Thanks,
Pushkar Khadilkar

[Pushkar Khadilkar]

Hi,

Create view statement is working appropriately as it does not go to Hivesterix / Hyracks.

The error comes when the view is used.

For example, q11_important_stock.hive (modified to use views, attached here) runs on Hive.

We could not run it on Hivesterix. The stack trace is 

java.lang.NullPointerException

at edu.uci.ics.hivesterix.logical.plan.visitor.JoinVisitor.generateJoinTree(JoinVisitor.java:296)

at edu.uci.ics.hivesterix.logical.plan.visitor.JoinVisitor.translateJoinOperator(JoinVisitor.java:153)

at edu.uci.ics.hivesterix.logical.plan.visitor.JoinVisitor.visit(JoinVisitor.java:100)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:297)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:394)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:394)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:394)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:394)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:394)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:394)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:394)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:394)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:394)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:394)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:394)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:394)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:394)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:394)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:394)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:394)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:394)

at edu.uci.ics.hivesterix.logical.plan.HiveAlgebricksTranslator.translate(HiveAlgebricksTranslator.java:260)

at pyroj.runtime.hyracks.ExecutionEngine.compileJob(ExecutionEngine.java:210)

at pyroj.runtime.hyracks.HivesterixDriver.compile(HivesterixDriver.java:547)

at pyroj.runtime.hyracks.HivesterixDriver.compile(HivesterixDriver.java:370)

at pyroj.runtime.hyracks.HivesterixDriver.run(HivesterixDriver.java:928)

at pyroj.runtime.hyracks.ScriptDriver.runScript(ScriptDriver.java:55)

at pyroj.runtime.hyracks.ScriptDriver.main(ScriptDriver.java:65)

If this feature is not supported, any inputs on changes needed in Hivesterix to add this would be helpful.

Thanks,

Pushkar Khadilkar