Hello Wangchangchun, On Tue, Aug 25, 2015 at 12:34 PM, Wangchangchun (A) < [email protected]> wrote:
> HI, can anyone answer me two questions? > > 1. > > IN “run-examples.sh”, the queries that is “dimension-queries.sql” and > “cube-queries.sql”, > > Is there a sql will execute on jdbc and also on hive, and then join the > results of them. I want to use a case to track the code implemention. > > run-examples.sh would run fine out of the box with default setup, unless you modified hivedriver-site.xml and jdbcdriver-site.xml to point to some thing else. run-examples.sh runqueries will run all queries in dimension-queries.sql and cube-queries.sql. You have to run run-examples.sh sample-metastore run-examples.sh populate-metastore before running runqueries. > > 2. > > Whether lens support some native tables in jdbc-compiant database, some > other native tables in hive, and a sql will join the results of these two > tables? > Lens supports native table queries in jdbc-complaint database and also other native table queries in hive. But you cannot join the results from jdbc and hive. Thanks Amareshwari
