Thank you for the response. The variable is set according to 'set;'. I've tried
your suggestion prior to posting, I've also tried removing the single quotes in
the value and then tried putting ${hiveconf:rootpath} inside quotes i.e.
'${hiveconf:rootpath} ' and without quotes. Whenever I put ${hiveconf:rootpath}
inside quotes, the error changes to:
FAILED: IllegalArgumentException Can not create a Path from an empty string
Cheers,
Yonathan Maalo
BT Technology, Service & Operations
Mob: 07483981150
Email: [email protected]
-----Original Message-----
From: Per Ullberg [mailto:[email protected]]
Sent: 22 June 2016 18:49
To: [email protected]
Subject: Re: Create table with parameterized location
Try to skip the spaces when doing the set.
You can execute 'set;' to verify that rootpath is set as expected.
/Pelle
On Wednesday, June 22, 2016, <[email protected]> wrote:
> Hello,
> I've tried something like the following
>
> set rootpath = 'hdfs_path';
> DROP TABLE mytable;
> CREATE [EXTERNAL] TABLE mytable (
> Dim1 STRING,
> Dim2 STRING,
> Dim3 STRING )
> LOCATION ${hiveconf:rootpath};
>
> I get this error:
>
>
> FAILED: ParseException line 1:126 mismatched input '<EOF>' expecting
> StringLiteral near 'LOCATION' in table location specification
>
> I am using Hive 1.1.0 with Cloudera 5.4.8.
>
> Does anyone have an idea how to solve this?
>
> All the best,
>
> Yonathan
>
>
--
*Per Ullberg*
Tech Lead
Odin - Uppsala
Klarna AB
Sveavägen 46, 111 34 Stockholm
Tel: +46 8 120 120 00
Reg no: 556737-0431
klarna.com
