[
https://issues.apache.org/jira/browse/TAJO-1081?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14152768#comment-14152768
]
Mai Hai Thanh commented on TAJO-1081:
-------------------------------------
Hi Hyunsik,
I have examined the bug. The problem is that the "number of rows" information
is not provided when a table is created (This is also true for sample TPC-H
tables in the unit tests). However, computing the number of rows given a data
file may take a lot of time when the table is big, stored in a binary file
format, and organized in a complex file type. The cost of computing row count
may be similar to that of executing the "select count(*) from table_name"
query. So, I think that we should remove the "number of rows" information in
the response to "\d table_name" command. Even though this information might be
computed sometime, somewhere, a "\d" command may be issued just right after a
"create external table" command. How do you think about it ?
> Non-forwarded (simple) query shows wrong rows.
> ----------------------------------------------
>
> Key: TAJO-1081
> URL: https://issues.apache.org/jira/browse/TAJO-1081
> Project: Tajo
> Issue Type: Bug
> Components: client, tajo master
> Reporter: Hyunsik Choi
> Assignee: Mai Hai Thanh
> Priority: Blocker
> Fix For: 0.9.0
>
>
> Non-forward queries show wrong rows. It is the very urgent and critical bug
> that must be resolved before 0.9.0 release.
> {code}
> default> \d region
> table name: default.region
> table path: file:/Users/hyunsik/tpch/region
> store type: CSV
> number of rows: 0
> volume: 494 B
> Options:
> 'csvfile.delimiter'='|'
> schema:
> r_regionkey INT8
> r_name TEXT
> r_comment TEXT
> default>
> default> select * from region;
> r_regionkey, r_name, r_comment
> -------------------------------
> , ,
> 2, ,
> , ,
> , ,
> , ,
> , ,
> , ,
> , ,
> , ,
> , "
> � (0,
> 0, AFRICA, lar deposits. blithely final packages cajole. regular waters are
> final requests. regular accounts are according to
> 1, AMERICA, hs use ironic, even requests. s
> 2, ASIA, ges. thinly even pinto beans ca
> 3, EUROPE, ly final courts cajole furiously final excuse
> 4, MIDDLE EAST, uickly special accounts cajole carefully blithely close
> requests. carefully final asymptotes haggle furiousl
> (15 rows, 0.03 sec, 494 B selected)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
