About felicien_cather

felicien_cather · ‎06-08-2017

@Bala Vignesh N V The error is the same as shown in my previous screenshot, here is the error stackTrace if it can help : errorhive.txt

felicien_cather · ‎06-08-2017

@Bala Vignesh N V Still not, I realy don't understand where this problem come from...

felicien_cather · ‎06-08-2017

Hi @Bala Vignesh N V, Thanks for your fast answer ! I tried to add ROW format delimited but it didin't change the error I also tried to change the order of the keywords (some say that "LOCATION" has to be before "TBLPROPERTIES") but it didn't change anything either

felicien_cather · ‎06-08-2017

Hi, I was following the tutorial (i'm not using the sandbox) and everything was clear, until "FORMAT THE DATA WITH HIVE" I pasted the code : CREATE TABLE FIREWALL_LOGS( time STRING, ip STRING, country STRING, status INT ) CLUSTERED BY (time) into 25 buckets STORED AS ORC TBLPROPERTIES("transactional"="true") FIELDS TERMINATED BY '|' LOCATION '/tmp/server-logs'; and got this error : "org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 10:0 missing EOF at 'FIELDS' near ')' This seems to be a common error with hive but everything I tried doesn't help. If someone has an idea it would be very usefull ! Thanks in advance

felicien_cather · ‎03-23-2017

http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.3/bk_command-line-installation/content/before_you_begin.html This install document says that it's only possible to install hue on centOS, RHEL or SLES. I wondered if there is a other way to install it on my HDP cluster ? thanks !

Online	Offline
Last Visited	‎08-18-2017 11:49 AM

Member Since	‎03-22-2017 03:31 PM
Last Visited	‎08-18-2017 11:49 AM
Posts	9

Cloudera Community

Re: error while creating hive table

Re: error while creating hive table

Re: error while creating hive table

error while creating hive table

Install hue on HDP 2.5.3 on DEBIAN 7