Member since
09-25-2017
5
Posts
0
Kudos Received
0
Solutions
10-20-2017
11:38 PM
Thanks Sandeep. Issue was we are using older version of phoenix 4.4 , some one copied 4.8 phoenix jars to server that lead me believe we are using 4.8 but actually servers are of version 4.4.
... View more
10-20-2017
08:15 AM
I was able to create phoenix table by hive cli,
but insert fails. Any pointers on why its failing?
In hive client : ADD JARS
/usr/hdp/2.3.2.0-2950/apache-phoenix-4.8.2-HBase-1.0-bin/phoenix-hive-4.8.2-HBase-1.0.jar;
insert into table sud_test values ("xx",1, 2.0,
3.0);
Error: java.lang.RuntimeException: Error in configuring
object
at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:112)
...
Caused by: java.lang.reflect.InvocationTargetException
at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
....
Caused by: java.lang.RuntimeException: Error in configuring
object
at
org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:112)
Caused by: java.lang.RuntimeException: Map operator
initialization failed
at
org.apache.hadoop.hive.ql.exec.mr.ExecMapper.configure(ExecMapper.java:140)
... 22 more
Caused by: java.lang.NoSuchMethodError:
org.apache.phoenix.util.QueryUtil.getUrl(Ljava/lang/String;Ljava/lang/Integer;Ljava/lang/String;)Ljava/lang/String;
at org.apache.phoenix.hive.util.PhoenixConnectionUtil.getConnection(PhoenixConnectionUtil.java:93)
... View more
Labels:
- Labels:
-
Apache HBase
-
Apache Hive
-
Apache Phoenix
10-16-2017
11:21 PM
"The Hive CLI, which connects directly to HDFS and the Hive Metastore" so hive cli does everything on client side that hiveserver2 is doing. Hive cli has extra overhead of instantiating before MR, my question will that affect performance, specially when you invoke hive cli repetedly?
... View more
10-16-2017
01:10 PM
For a simple query beeline is around 4 times faster than hive cli for query executed with -e.
... View more
10-16-2017
01:10 PM
How is beeline performance compared to hive cli? I know hive cli is deprecated and not encouraged to use, but it would be helpful if you already did performance comparison of beeline and hive cli and can share the results?
... View more
Labels:
- Labels:
-
Apache Hive