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
