Re: Hive 2.1.1 Error: com.google.protobuf.UnmodifiableLazyStringList does not implement the requested interface com.google.protobuf.ProtocolStringList

2017-05-11 Thread Ascot Moss
Anyone uses Hive 2.1.1? please help On Thu, May 11, 2017 at 9:53 PM, Ascot Moss wrote: > I ran the following simple SQLs: > > create table Customers (CustomerName STRING, ContactName STRING, Address > STRING,, City STRING,, PostalCode STRING,, Country STRING,); > > INSERT

Fwd: Why spark.sql.autoBroadcastJoinThreshold not available

2017-05-11 Thread Jone Zhang
Solve it by remove lazy identity. 2.HiveContext.sql("cache table feature as "select * from src where ...) which result size is only 100K -- Forwarded message -- From: Jone Zhang Date: 2017-05-10 19:10 GMT+08:00 Subject: Why

Re: Hive 2.1.1 Error: com.google.protobuf.UnmodifiableLazyStringList does not implement the requested interface com.google.protobuf.ProtocolStringList

2017-05-11 Thread Ascot Moss
I ran the following simple SQLs: create table Customers (CustomerName STRING, ContactName STRING, Address STRING,, City STRING,, PostalCode STRING,, Country STRING,); INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country) VALUES ('Cardinal', 'Tom B. Erichsen',

Re: SQL Standard Based Hive Authorization with CDH 5.X

2017-05-11 Thread Rob Anderson
You add the options to HiveServer2 Environment Advanced Configuration Snippet (Safety Valve) via: HIVE_OPTS=--hiveconf hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory --hiveconf hive.security.authorization.enabled=true

Hive 2.1.1 Error: com.google.protobuf.UnmodifiableLazyStringList does not implement the requested interface com.google.protobuf.ProtocolStringList

2017-05-11 Thread Ascot Moss
Hi, I tried Hive 2.1.1 and got following error: java.io.IOException: com.google.protobuf.ServiceException: java.lang.IncompatibleClassChangeError: Class com.google.protobuf.UnmodifiableLazyStringList does not implement the requested interface com.google.protobuf.ProtocolStringList OS: RH7 Java:

Re: SQL Standard Based Hive Authorization with CDH 5.X

2017-05-11 Thread Thejas Nair
You can also set them via hiveserver2-site.xml instead of passing them as commandline params. Let me make that more clear in the doc. On Thu, May 11, 2017 at 9:36 AM, Rob Anderson wrote: > You add the options to HiveServer2 Environment Advanced Configuration >