java - Spark submit: Table or view not found using jar -
when run hiveread.java
intellij ide can run , result. created jar file ( it's maven project ) , tried run ide, gave me
classloaderresolver class "" gave error on creation : {1}
then looked @ answers , found had add datanulcues jars, did this
java -jar /home/saurab/sparkprojects/spark_hive/target/myjar-jar-with-dependencies.jar --jars jars/datanucleus-api-jdo-3.2.6.jar,jars/datanucleus-core-3.2.10.jar,jars/datanucleus-rdbms-3.2.9.jar,/home/saurab/hadoopec/hive/lib/mysql-connector-java-5.1.38.jar
then got error
org.datanucleus.exceptions.nucleususerexception: persistence process has been specified use classloaderresolver of name "datanucleus" yet has not been found datanucleus plugin mechanism. please check classpath , plugin specification.
somewhere found should spark-submit
. did this
./bin/spark-submit --class hiveread --master yarn --jars jars/datanucleus-api-jdo-3.2.6.jar,jars/datanucleus-core-3.2.10.jar,jars/datanucleus-rdbms-3.2.9.jar,/home/saurab/hadoopec/hive/lib/mysql-connector-java-5.1.38.jar --files /home/saurab/hadoopec/spark/conf/hive-site.xml /home/saurab/sparkprojects/spark_hive/target/myjar-jar-with-dependencies.jar
now new type of error
table or view not found: `bigmart`.`o_sales`;
help me !! :)
i have copied hive-site.xml
/spark/conf
, started hive-metastore service ( hiveserver2 --service metastore
)
here hiveread.java code if interested.
Comments
Post a Comment