You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Jaehwa Jung (JIRA)" <ji...@apache.org> on 2015/07/24 04:39:07 UTC
[jira] [Assigned] (TAJO-1676) Queries on
information_schema.partitions table return invalid result
[ https://issues.apache.org/jira/browse/TAJO-1676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jaehwa Jung reassigned TAJO-1676:
---------------------------------
Assignee: Jaehwa Jung
> Queries on information_schema.partitions table return invalid result
> --------------------------------------------------------------------
>
> Key: TAJO-1676
> URL: https://issues.apache.org/jira/browse/TAJO-1676
> Project: Tajo
> Issue Type: Bug
> Reporter: Jihoon Son
> Assignee: Jaehwa Jung
> Fix For: 0.11.0
>
>
> See the title.
> You can reproduce as follows.
> {noformat}
> default> create table partitioned_nation (n_name text, n_comment text) partition by column (n_nationkey int8, n_regionkey int8) ;
> OK
> default> insert into partitioned_nation select * from nation;
> Progress: 100%, response time: 0.811 sec
> (25 rows, 0.811 sec, 267 B inserted)
> default> \d partitioned_nation
> table name: default.partitioned_nation
> table uri: hdfs://localhost:7020/tajo/warehouse/default/partitioned_nation
> store type: CSV
> number of rows: 0
> volume: 0 B
> Options:
> 'text.delimiter'='|'
> schema:
> n_name TEXT
> n_comment TEXT
> Partitions:
> type:COLUMN
> columns::n_nationkey (INT8), n_regionkey (INT8)
> information_schema> \dfs -ls hdfs://localhost:7020/tajo/warehouse/default/partitioned_nation/
> Found 5 items
> drwxr-xr-x - jihoonson supergroup 0 2015-07-06 18:14 hdfs://localhost:7020/tajo/warehouse/default/partitioned_nation/n_nationkey=0
> drwxr-xr-x - jihoonson supergroup 0 2015-07-06 18:14 hdfs://localhost:7020/tajo/warehouse/default/partitioned_nation/n_nationkey=1
> drwxr-xr-x - jihoonson supergroup 0 2015-07-06 18:14 hdfs://localhost:7020/tajo/warehouse/default/partitioned_nation/n_nationkey=2
> drwxr-xr-x - jihoonson supergroup 0 2015-07-06 18:14 hdfs://localhost:7020/tajo/warehouse/default/partitioned_nation/n_nationkey=3
> drwxr-xr-x - jihoonson supergroup 0 2015-07-06 18:14 hdfs://localhost:7020/tajo/warehouse/default/partitioned_nation/n_nationkey=4
> information_schema> select * from partitions;
> partition_id, tid, partition_name, path
> -------------------------------
> (0 rows, 0.008 sec, 0 B selected)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)