Re: The metastore database gives errors when start spark-sql CLI.

2016-05-13 Thread Mich Talebzadeh
I do not know Postgres but that sounds like a system table much like Oracle v$instance? Why running a Hive schema script against a hive schema/DB in Postgres should impact system schema? Mine is Oracle s...@mydb12.mich.LOCAL> SELECT version FROM v$instance; VERSION - 12.1.0.2.0

The metastore database gives errors when start spark-sql CLI.

2016-05-13 Thread Joseph
Hi all, I use PostgreSQL to store the hive metadata. First, I imported a sql script to metastore database as follows: psql -U postgres -d metastore -h 192.168.50.30 -f hive-schema-1.2.0.postgres.sql Then, when I started $SPARK_HOME/bin/spark-sql, the PostgreSQL gave the following