Re: hive create table error

2015-10-12 Thread Sanjeev Verma
s. > From: Sanjeev Verma > Reply-To: "user@hive.apache.org" > Date: Monday, October 12, 2015 at 2:07 AM > To: "user@hive.apache.org" , "d...@hive.apache.org" < > d...@hive.apache.org> > Subject: hive create table error > > I am creating a

Re: hive create table error

2015-10-12 Thread Syed Abulullah
.apache.org>" mailto:d...@hive.apache.org>> Subject: hive create table error I am creating a table from the two parquet partioned tables and getting the error duplicate column. any idea whats going wrong here. create table sample_table AS select * from parquet_table par inn

hive create table error

2015-10-12 Thread Sanjeev Verma
I am creating a table from the two parquet partioned tables and getting the error duplicate column. any idea whats going wrong here. create table sample_table AS select * from parquet_table par inner join parquet_table_counter ptc ON ptc.user_di=par.user_id; FAILED: SemanticException [Error 100

Re: Create Table Error

2011-03-22 Thread Anja Gruenheid
Hi! Where (and what) exactly do I have to set it? I added HADOOP_CONF_DIR to the path variables and to the source folders in the build path, but it doesn't work. Thanks, Anja On 03/22/2011 04:48 AM, Thiruvel Thirumoolan wrote: Looks like your IDE classpath does not include HADOOP_CONF_DIR.

Re: Create Table Error

2011-03-22 Thread Thiruvel Thirumoolan
Looks like your IDE classpath does not include HADOOP_CONF_DIR. Your warehouse and tmp dirs are in Hadoop and the table dir creation failures are in local file system. On Mar 22, 2011, at 4:40 AM, Anja Gruenheid wrote: > Hi! > > I've tried to run a create table statement via the HiveCLI in Ec

Create Table Error

2011-03-21 Thread Anja Gruenheid
Hi! I've tried to run a create table statement via the HiveCLI in Eclipse and it fails with the following exception: FAILED: Error in metadata: MetaException(message:Got exception: java.io.FileNotFoundException File file:/user/hive/warehouse/customer does not exist.) 11/03/21 19:05:36 ERROR ex

Re: create table error

2011-01-28 Thread Thiruvel Thirumoolan
A web search of that exception should lead you to that recommendation (or use MIXED instead of ROW or disable binary logging at all if you don't want replication). On Jan 28, 2011, at 7:52 PM, Thiruvel Thirumoolan wrote: Can you change your MySQL configuration "binlog_format" to "ROW" ? It sho

Re: create table error

2011-01-28 Thread Thiruvel Thirumoolan
Can you change your MySQL configuration "binlog_format" to "ROW" ? It should be in /etc/my.cnf I guess. Remember to restart mysql server. -Thiruvel On Jan 28, 2011, at 7:27 PM, Ajo Fod wrote: Seems like you are using a MySQL metadata store ... do you have write permissions on the store? ... ca

Re: create table error

2011-01-28 Thread Ajo Fod
Seems like you are using a MySQL metadata store ... do you have write permissions on the store? ... can you create another table? If not, perhaps you can try with the plain vanilla metastore and see if the problem persists. -Ajo. On Fri, Jan 28, 2011 at 2:31 AM, lei liu wrote: > When I execu

Re: create table error

2011-01-28 Thread Laurent Laborde
I don't know the reason. But i tested it on my computer and it works. -- Laurent "ker2x" Laborde Sysadmin & DBA at http://www.over-blog.com/

create table error

2011-01-28 Thread lei liu
When I execute "create table tag16(auction int, tagid int, cost double, title string, description string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','" , the hive throw "AILED: Error in metadata: javax.jdo.JDOException: Couldnt obtain a new sequence (unique id) : Binary logging not possible. Mess