Mailing-List: contact dev-help@tajo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@tajo.apache.org
Received-SPF: pass (athena.apache.org: domain of azuryyyu@gmail.com designates
 209.85.192.54 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CALr1C9o-8nMuLXuRYjw0G-KSSxoEa9tYf8OJwVyh9EufmOPSOw@mail.gmail.com>
References: 
 <CALr1C9o-8nMuLXuRYjw0G-KSSxoEa9tYf8OJwVyh9EufmOPSOw@mail.gmail.com>
Date: Thu, 17 Apr 2014 16:19:22 +0800
Message-ID: 
 <CALr1C9r5u0u5rcM_RkDrVvjetU7cna0gdMA3iXArU8Pf=WR1gA@mail.gmail.com>
Subject: Re: Tajo cannot recognize external table in Hive
From: Azuryy Yu <azuryyyu@gmail.com>
To: "dev@tajo.apache.org" <dev@tajo.apache.org>
Content-Type: multipart/alternative; boundary=001a11c2ee64c8f07e04f738b0d3

--001a11c2ee64c8f07e04f738b0d3
Content-Type: text/plain; charset=UTF-8

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 <azuryyyu@gmail.com> 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.
>

--001a11c2ee64c8f07e04f738b0d3--