I created an external hive table: test
CREATE EXTERNAL TABLE test(id string) PARTITIONED BY (dt string);


then;
alter table test add partition (dt='20140410') location '/data/20130410';

finally, I can \d test in the tsql shell, but there is no query result as
expected.



On Thu, Apr 17, 2014 at 1:47 PM, Azuryy Yu <[email protected]> wrote:

> Hi,
> I'm using HCatalogStore, and there are some external tables in Hive.
>
> Tajo cannot recognized these external tables during my query.
>
> after '\d tablename',  it shows as following:
>
> default> \d test
>
> table name: default.test
> table path: hdfs://test-cluster/hive/warehouse/test
>
> the red font path name is not the partition located directory, so there is
> no query result returned.
>

Reply via email to