Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive Partitioning

avatar
Contributor

Hi All,

 

I am using cloudera 4.3.0. (System Config:-iIntel i3 Processor with 8GB RAM)Trying to create a Partitioning in Hive. Below is the detail:-

 

CREATE TABLE partitioned_user(
firstname VARCHAR(64),
lastname VARCHAR(64),
address STRING,
city VARCHAR(64),
post STRING,
phone1 VARCHAR(64),
phone2 STRING,
email STRING,
web STRING
)
PARTITIONED BY (country VARCHAR(64), state VARCHAR(64))
STORED AS SEQUENCEFILE;

 

But getting error as "FAILED: ParseException line 2:10 cannot recognize input near 'VARCHAR' '(' '64' in column type".

 

Can anyone please assist.

 

Thank You.

1 ACCEPTED SOLUTION

avatar
Community Manager

Following up on this. I can confirm that the Launch Cloudera Manager icon has been replaced with icons to lauch Cloudera express or the Cloudera Enterprise trial. The team is working to update the wording on the download page to reflect this. Sorry for the confusion. 


Cy Jervis, Manager, Community Program
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

View solution in original post

10 REPLIES 10

avatar
Community Manager

My understanding is that the Quickstart VM will not change the icon and it will remain with the new wording. The only changes will be to the download page and other documentation that reference launching Cloudera Manager in the VM. You only need to use those icons if you wish to use Cloudera Manager otherwise you simply use CDH manually. Here is a page explaining the differences between Cloudera Express and Cloudera Enterprise. Keep in mind that the Cloudera Enterprise icon only e nables the additional features for a trial period. If you only need to use Cloudera Manager the Cloudera Express route is your most likely route.

 

Also keep in mind that when using Cloudera Manager there is a greater need for resources to be allocated to the VM to handle it. You can read about it in the How to setup a Cloudera Quickstart Virtual Machine article.


Cy Jervis, Manager, Community Program
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.