0

I have configured 3 node Spark (version 1.4.0) cluster environment with Hive 0.13.1 version. and started Spark thrift service using ./sbin/start-thriftserver.sh.

Multiple users are using same thrift service with same port and different usernames.

But the problem is that when one user executes query like use mytest. then database change is automatically reflects for other users.

zero323
  • 322,348
  • 103
  • 959
  • 935
Kaushal
  • 3,237
  • 3
  • 29
  • 48

1 Answers1

0

Have you set hive concurrency values as mentioned in the docs:

https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-ConfigurationValuestoSetforINSERT,UPDATE,DELETE

Configuration Values to Set for INSERT, UPDATE, DELETE
In addition to the new parameters listed above, some existing parameters need to be set to support INSERT ... VALUES, UPDATE, and DELETE.
Configuration key
Must be set to
hive.support.concurrency    true (default is false)
hive.enforce.bucketing  true (default is false)
hive.exec.dynamic.partition.mode    nonstrict (default is strict)
WestCoastProjects
  • 58,982
  • 91
  • 316
  • 560
  • I changed above configuration settings but that also not works for me. And above properties (hive.enforce.bucketing & hive.exec.dynamic.partition.mode) only works with (Hive 0.14.0 and later) and one more thing, Spark SQL doesn’t support buckets yet. – Kaushal Aug 26 '15 at 04:54