[
https://issues.apache.org/jira/browse/TAJO-1411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14366834#comment-14366834
]
Hyunsik Choi edited comment on TAJO-1411 at 3/18/15 8:46 AM:
-------------------------------------------------------------
I'm going to show an example. It would be more comprehensive than the article I
mentioned.
{code}
default> \d
No Relation Found
default> create table table1 (a int);
OK
default> create table "Table2" (a int);
OK
default> \d
Table2
table1
default> \d table1
table name: default.table1
table path: hdfs://localhost:8020/tajo/warehouse/default/table1
store type: CSV
number of rows: 0
volume: 0 B
Options:
'text.delimiter'='|'
schema:
a INT4
default> \d table2
ERROR: no such a table: table2
com.google.protobuf.ServiceException: java.sql.SQLException: ERROR: no such a
table: table2
default> \d Table2
table name: default.Table2
table path: hdfs://localhost:8020/tajo/warehouse/default/Table2
store type: CSV
number of rows: 0
volume: 0 B
Options:
'text.delimiter'='|'
schema:
a INT4
default>
{code}
was (Author: hyunsik):
I'm going to show an example. It would be more comprehensive than the article I
mentioned.
{noformat}
default> \d
No Relation Found
default> create table table1 (a int);
OK
default> create table "Table2" (a int);
OK
default> \d
Table2
table1
default> \d table1
table name: default.table1
table path: hdfs://localhost:8020/tajo/warehouse/default/table1
store type: CSV
number of rows: 0
volume: 0 B
Options:
'text.delimiter'='|'
schema:
a INT4
default> \d table2
ERROR: no such a table: table2
com.google.protobuf.ServiceException: java.sql.SQLException: ERROR: no such a
table: table2
default> \d Table2
table name: default.Table2
table path: hdfs://localhost:8020/tajo/warehouse/default/Table2
store type: CSV
number of rows: 0
volume: 0 B
Options:
'text.delimiter'='|'
schema:
a INT4
default>
{noformat}
> Support case-insensitive table description command
> --------------------------------------------------
>
> Key: TAJO-1411
> URL: https://issues.apache.org/jira/browse/TAJO-1411
> Project: Tajo
> Issue Type: Bug
> Components: cli
> Affects Versions: 0.10.1
> Environment: Tajo 0.11.0-SNAPSHOT (rev. 82d44af source checksum
> 8f4cffc)
> Reporter: Dongjoon Hyun
> Assignee: Dongjoon Hyun
> Fix For: 0.10.1
>
>
> In `tsql`, 'describe table' command is case-sensitive inconsistently with
> other features.
> {code:sql}
> default> create table Customer(id int);
> OK
> default> select * from Customer;
> id
> -------------------------------
> (0 rows, 0.187 sec, 0 B selected)
> default> \d Customer;
> ERROR: no such a table: Customer
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
