Re: creating database issue

2021-12-07 Thread bitfox
And, I can't start spark-sql shell, the error as below. Does this mean I need to install Hive on local machine? Caused by: java.sql.SQLException: Failed to start database 'metastore_db' with class loader jdk.internal.loader.ClassLoaders$AppClassLoader@5ffd2b27, see the next exception for

Re: creating database issue

2021-12-07 Thread bitfox
Hello This is just a standalone deployment for testing purpose. The version: Spark 3.2.0 (git revision 5d45a415f3) built for Hadoop 3.3.1 Build flags: -B -Pmesos -Pyarn -Pkubernetes -Psparkr -Pscala-2.12 -Phadoop-3.2 -Phive -Phive-thriftserver I just started one master and one worker for the

Re: creating database issue

2021-12-07 Thread Qian Sun
Hi, It seems to be a hms question. Would u like to provide the information about spark version, hive version and spark application configuration? Best > 2021年12月8日 上午9:04,bitfox 写道: > > sorry I am newbie to spark. > > When I created a database in pyspark shell following the book content

creating database issue

2021-12-07 Thread bitfox
sorry I am newbie to spark. When I created a database in pyspark shell following the book content of learning spark 2.0, it gets: >>> spark.sql("CREATE DATABASE learn_spark_db") 21/12/08 09:01:34 WARN HiveConf: HiveConf of name hive.stats.jdbc.timeout does not exist 21/12/08 09:01:34 WARN

Re: start-history-server.sh doesn't survive system reboot. Recommendation?

2021-12-07 Thread Mich Talebzadeh
One way would be to cron the startup script 1. enable cron on the host and Unix login that runs $SPARK_HOME/sbin/start-history-server.sh where $SPARK_HOME is set in below cron to absolute value say /opt/spark. You can run it as non root, putting it in the crontab of the corresponding

Re: start-history-server.sh doesn't survive system reboot. Recommendation?

2021-12-07 Thread Sean Owen
The scripts just launch the processes. To make any process restart on system restart, you would need to set it up as a system service (i.e. controlled by 'service'). That's easy enough but out of scope for Spark itself. On Tue, Dec 7, 2021 at 3:23 PM James Yu wrote: > Hi Users, > > We found

start-history-server.sh doesn't survive system reboot. Recommendation?

2021-12-07 Thread James Yu
Hi Users, We found that the history server launched by using the "start-history-server.sh" command does not survive system reboot. Any recommendation of making it always up even after reboot? Thanks, James