Create table with parameterized location

[yonathan.maalo]

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