Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Error while creating a table with 'LIKE' clause

Solved Go to solution

Error while creating a table with 'LIKE' clause

New Contributor

I am trying this

create table emp1 LIKE emp CLUSTERED BY () INTO 4 BUCKETS STORED AS ORC;

Its giving a parse exception :

  1. rg.apache.ambari.view.hive.client.HiveInvalidQueryException:Errorwhile compiling statement: FAILED:ParseException line 4:42 missing EOF at 'CLUSTERED' near 'emp'[ERROR_STATUS]
  2. org.apache.ambari.view.hive.client.HiveInvalidQueryException:Errorwhile compiling statement: FAILED:ParseException line 4:42 missing EOF at 'CLUSTERED' near 'emp'[ERROR_STATUS]
  3. at org.apache.ambari.view.hive.client.Utils.verifySuccess(Utils.java:46)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Error while creating a table with 'LIKE' clause

Contributor

You will need to specify the column you are clustering on, and then achieve it in multiple statements:

CREATE TABLE emp1 LIKE emp;
ALTER TABLE emp1 SET FILEFORMAT ORC;
ALTER TABLE emp1 CLUSTERED BY (empId) INTO 4 BUCKETS;
2 REPLIES 2

Re: Error while creating a table with 'LIKE' clause

@sanjeevan mahajan

I don't think you can define other attributes while creating table with "LIKE" option, in theory with "LIKE" it will copy the existing table definition and other attributes. Its better to use alter table after creating it with "LIKE".

EDITED: I think you can change no. of buckets with alter command if you already defined it previously.

Highlighted

Re: Error while creating a table with 'LIKE' clause

Contributor

You will need to specify the column you are clustering on, and then achieve it in multiple statements:

CREATE TABLE emp1 LIKE emp;
ALTER TABLE emp1 SET FILEFORMAT ORC;
ALTER TABLE emp1 CLUSTERED BY (empId) INTO 4 BUCKETS;
Don't have an account?
Coming from Hortonworks? Activate your account here