Member since
03-22-2017
9
Posts
0
Kudos Received
0
Solutions
06-08-2017
03:37 PM
@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
... View more
06-08-2017
01:58 PM
@Bala Vignesh N V
Still not, I realy don't understand where this problem come from...
... View more
06-08-2017
01:03 PM
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
... View more
06-08-2017
11:45 AM
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
... View more
Labels:
03-23-2017
03:50 PM
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 !
... View more
Labels: