[
https://issues.apache.org/jira/browse/TAJO-2164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15349042#comment-15349042
]
ASF GitHub Bot commented on TAJO-2164:
--------------------------------------
Github user jihoonson commented on the issue:
https://github.com/apache/tajo/pull/1033
Jaehwa looks busy, so I'll commit this patch soon.
> SequenceFile print wrong values with TextSerializerDeserializer
> ---------------------------------------------------------------
>
> Key: TAJO-2164
> URL: https://issues.apache.org/jira/browse/TAJO-2164
> Project: Tajo
> Issue Type: Bug
> Components: Storage
> Reporter: Jaehwa Jung
> Assignee: Jaehwa Jung
>
> Currently, SequenceFile print wrong values on tsql with
> TextSerializerDeserializer as follows.
> * Tajo version: 0.12.0-SNAPSHOT
> * Catalog: HiveCatalogStore
> * Dataset: TPC-H 1G
> * Create table on hive
> {code:xml}
> CREATE TABLE lineitem_p (
> l_orderkey int,
> l_partkey int,
> l_suppkey int,
> l_linenumber int,
> l_quantity double,
> l_extendedprice double,
> l_discount double,
> l_tax double,
> l_returnflag string,
> l_linestatus string,
> l_commitdate string,
> l_shipinstruct string,
> l_shipmode string,
> l_comment string)
> PARTITIONED BY(l_shipdate string, l_receiptdate string)
> ROW FORMAT DELIMITED
> FIELDS TERMINATED BY '\u0001'
> STORED AS SEQUENCEFILE;
> INSERT OVERWRITE TABLE lineitem_p
> PARTITION (L_SHIPDATE, L_RECEIPTDATE)
> SELECT L_ORDERKEY, L_PARTKEY, L_SUPPKEY, L_LINENUMBER, L_QUANTITY,
> L_EXTENDEDPRICE, L_DISCOUNT, L_TAX, L_RETURNFLAG, L_LINESTATUS, L_COMMITDATE,
> L_SHIPINSTRUCT, L_SHIPMODE, L_COMMENT, L_SHIPDATE, L_RECEIPTDATE
> FROM LINEITEM
> WHERE L_SHIPDATE < '1992-03-01';
> {code}
> * Bugs on tsql
> {code:xml}
> select * from lineitem_p limit 10;
> l_orderkey, l_partkey, l_suppkey, l_linenumber, l_quantity,
> l_extendedprice, l_discount, l_tax, l_returnflag, l_linestatus,
> l_commitdate, l_shipinstruct, l_shipmode, l_comment, l_shipdate,
> l_receiptdate
> -------------------------------
> , , , , , , , , , , , , , , 1992-01-02, 1992-01-05
> , , , , , , , , , , , , , , 1992-01-02, 1992-01-07
> , , , , , , , , , , , , , , 1992-01-02, 1992-01-09
> , , , , , , , , , , , , , , 1992-01-02, 1992-01-11
> , , , , , , , , , , , , , , 1992-01-02, 1992-01-14
> , , , , , , , , , , , , , , 1992-01-02, 1992-01-15
> , , , , , , , , , , , , , , 1992-01-02, 1992-01-15
> , , , , , , , , , , , , , , 1992-01-02, 1992-01-15
> , , , , , , , , , , , , , , 1992-01-02, 1992-01-15
> , , , , , , , , , , , , , , 1992-01-02, 1992-01-18
> (10 rows, 2.75 sec, 0 B selected)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
