Hi,
Can you use linux command *locate* to find jline jar file? It should be added
into the class path of HIVE. Another way is by running “export
HADOOP_USER_CLASSPATH_FIRST=true” instead of removing it.
Yours,
Ferdinand Xu
From: Srinivas Thunga [mailto:srinivas.thu...@gmail.com]
Sent: Tuesday,
hi Swagatika,
*base on further log file analysis i think problem with low disk space.*
*below is full stack trace.*
..
org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while
processing row (tag=1)
{key:{joinkey0:12},value:{_col2:.},alias:1} at
i have executed below Hive query
create table table_llv_N_C as select
table_line_n_passed.chromosome_number,table_line_n_passed.position,
table_line_c_passed.id from table_line_n_passed join table_line_c_passed on
(table_line_n_passed.chromosome_number=table_line_c_passed.chromosome_number)
Hi all,
MYSQL ERROR is resolved by creating metastore tables by using
HIVE-SCHEMA-0.14.0 from HIVE-1.2.0-SNAPSHOT
Thanks Regards
Amithsha
On Tue, Mar 10, 2015 at 2:31 PM, Amith sha amithsh...@gmail.com wrote:
Have tried that too
Dropped the database created a new one
But Same error
Hi,
Does any one know how to deploy a custom UDAF jar file in SparkSQL? Where
should i put the jar file so SparkSQL can pick it up and make it accessible
for SparkSQL applications?
I do not use spark-shell instead I want to use it in an spark application.
I posted same question to Spark
@Xuefu: Thanks, I know this. Since I haven't got any answer there I sought
maybe I could get some help here.
On Tue, Mar 10, 2015 at 2:42 PM, Xuefu Zhang xzh...@cloudera.com wrote:
This question seems more suitable to Spark community. FYI, this is Hive
user list.
On Tue, Mar 10, 2015 at 5:46
This question seems more suitable to Spark community. FYI, this is Hive
user list.
On Tue, Mar 10, 2015 at 5:46 AM, shahab shahab.mok...@gmail.com wrote:
Hi,
Does any one know how to deploy a custom UDAF jar file in SparkSQL? Where
should i put the jar file so SparkSQL can pick it up and
Hi,
I have set up hiverserv2 running on port 10010 and I can use beeline from
remote host to connect to the server host
beeline -u jdbc:hive2://rhes564:10010/default
org.apache.hive.jdbc.HiveDriver -n hduser -p x
scan complete in 5ms
Connecting to jdbc:hive2://rhes564:10010/default
Hey Viral,
Is there a similar config for tez ?
Thanks
On Mon, Mar 9, 2015 at 6:36 PM, Viral Bajaria viral.baja...@gmail.com
wrote:
We use the hive.job.name property to set meaningful job names. Look into
using that before submitting queries.
Thanks,
Viral
On Mon, Mar 9, 2015 at 2:47
hi, i'm using hdp2.2 (VM) with hive 0.14.0.2.2.0.0-2041.
did the following:
create table t1(id string);create table t2(id string);select
t1.INPUT__FILE__NAME from t1 join t2 on t1.id = t2.id
fails on: Execution failed with exit status: 2
notice this happens also on self joins:select
Hi,
I am working in hive-1.2.0-snapshot configuration.I have configured
metastore with mysql.I can create database and table.But when i try to
insert data into table, am facing following error.
hive insert into table test values (1);
Query ID =
Now i am able to create a metastore database after exporting the hive
in .bashrc But the same mysql error is found
Thanks Regards
Amithsha
On Tue, Mar 10, 2015 at 12:03 PM, Amith sha amithsh...@gmail.com wrote:
Hi all,
I have Configured Hive 1.1.0 in Hadoop 2.4.1 successfully.Have started
so can u suggest the solution
Thanks Regards
Amithsha
On Tue, Mar 10, 2015 at 12:53 PM, Srinivas Thunga
srinivas.thu...@gmail.com wrote:
Hi,
I guess you have the sql as
hive-schema-1.1.0.mysql.sql
for this you will get only 45 tables only as Nucleus will not be there.
I am also faced
Hi, all,
When I build hive source using Maven, it gets stuck in:
Downloading:
http://ec2-50-18-79-139.us-west-1.compute.amazonaws.com/data/spark_2.10-1.3-rc1/org/pentaho/pentaho-aggdesigner-algorithm/5.1.5-jhyde/pentaho-aggdesigner-algorithm-5.1.5-jhyde.pom;,
and I can't connect to the server
i am thinking to run hive-schema-0.14.0.mysql.sql. it will have 54 tables.
*Thanks Regards,*
*Srinivas T*
On Tue, Mar 10, 2015 at 12:55 PM, Amith sha amithsh...@gmail.com wrote:
so can u suggest the solution
Thanks Regards
Amithsha
On Tue, Mar 10, 2015 at 12:53 PM, Srinivas Thunga
ok thank you Srinivas wil try it and reply now
Thanks Regards
Amithsha
On Tue, Mar 10, 2015 at 12:59 PM, Srinivas Thunga
srinivas.thu...@gmail.com wrote:
i am thinking to run hive-schema-0.14.0.mysql.sql. it will have 54 tables.
Thanks Regards,
Srinivas T
On Tue, Mar 10, 2015 at 12:55
same error found while inserting into table
Thanks Regards
Amithsha
On Tue, Mar 10, 2015 at 12:29 PM, Mahesh Sankaran
sankarmahes...@gmail.com wrote:
Hi,
I am working in hive-1.2.0-snapshot configuration.I have configured
metastore with mysql.I can create database and table.But when i
Hi all,
I have Configured Hive 1.1.0 in Hadoop 2.4.1 successfully.Have started
the metastore by [ hive --service metastore -p 7099 ]
and got the log as
2015-03-10 11:32:42,649 ERROR [main]: DataNucleus.Datastore
(Log4JLogger.java:error(115)) - An exception was thrown while
adding/validating
Hi Srinivas
Have used hive-schema-0.14.0 but same error found
2015-03-10 13:04:03,829 ERROR [main]: DataNucleus.Datastore
(Log4JLogger.java:error(115)) - An exception was thrown while
adding/validating class(es) : Specified key was too long; max key
length is 767 bytes
From the sql code do you know which table and primary key it is complaining?
I have used the script for Oracle 11g and modified one work with SAP Sybase ASE
15.7 and they both worked fine.
HTH
Mich Talebzadeh
http://talebzadehmich.wordpress.com
Publications due shortly:
Creating in-memory
after executing this command
mysqluse metastoreDB
mysqlsource hive-schema--0.14.0.mysql.sql
i am getting this
ERROR 1061 (42000): Duplicate key name 'PCS_STATS_IDX'
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0
Have tried that too
Dropped the database created a new one
But Same error
Thanks Regards
Amithsha
On Tue, Mar 10, 2015 at 2:03 PM, Mich Talebzadeh m...@peridale.co.uk wrote:
OK not surprising the script does not have a means to drop the object before
creating it so the script is
22 matches
Mail list logo
