Re: Exception: "You must build Spark with Hive. Export 'SPARK_HIVE=true' and run build/sbt assembly"

2015-10-05 Thread Ted Yu
t; > >>> . >>> Everything is set (jdbc, ... Etc). >>> >>> To start playing with, I just wanted to connect to my Mysql database to >>> retrieve data from a table. >>> >>> Here is my code >>> >>> from pyspark.sql import HiveContex

Exception: "You must build Spark with Hive. Export 'SPARK_HIVE=true' and run build/sbt assembly"

2015-10-05 Thread cherah30
c").options(url = "jdbc:mysql://localhost:3306/my_bdd_name", driver = "com.mysql.jdbc.Driver", dbtable="bdd_My_table_nameXX", user ="my_id", password="my_pw").load() And here is the exception message : Exception: ("You must bui

Re: Exception: "You must build Spark with Hive. Export 'SPARK_HIVE=true' and run build/sbt assembly"

2015-10-05 Thread Ted Yu
.sql import HiveContext > df_mysql = sqlHiveContext.read.format("jdbc").options(url = > "jdbc:mysql://localhost:3306/my_bdd_name", driver = > "com.mysql.jdbc.Driver", > dbtable="bdd_My_table_nameXX", user ="my_id", password="my_pw&