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 errors:
ERROR: syntax error at or near "@@" at character 5
STATEMENT: SET @@session.sql_mode=ANSI_QUOTES
ERROR: relation "v$instance" does not exist at character 21
STATEMENT: SELECT version FROM v$instance
ERROR: column "version" does not exist at character 10
STATEMENT: SELECT @@version
This does not affect normal use, but maybe it is a bug! ( I use spark 1.6.1 and
hive 1.2.1)
Joseph
