finally got it work out, mimicked how spark added datanucleus jars in
compute-classpath.sh, and added the db2jcc*.jar in the classpath, it works
now.
Thanks!
On Tue, Jun 17, 2014 at 10:50 AM, Jenny Zhao wrote:
> Thanks Michael!
>
> as I run it using spark-shell, so I added both jars through
>
Thanks Michael!
as I run it using spark-shell, so I added both jars through bin/spark-shell
--jars options. I noticed if I don't pass these jars, it complains it
couldn't find the driver, if I pass them through --jars options, it
complains there is no suitable driver.
Regards.
On Tue, Jun 17,
First a clarification: Spark SQL does not talk to HiveServer2, as that
JDBC interface is for retrieving results from queries that are executed
using Hive. Instead Spark SQL will execute queries itself by directly
accessing your data using Spark.
Spark SQL's Hive module can use JDBC to connect to
Hi,
my hive configuration use db2 as it's metastore database, I have built
spark with the extra step sbt/sbt assembly/assembly to include the
dependency jars. and copied HIVE_HOME/conf/hive-site.xml under spark/conf.
when I ran :
hql("CREATE TABLE IF NOT EXISTS src (key INT, value STRING)")
got