[ 
https://issues.apache.org/jira/browse/TAJO-2164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15303741#comment-15303741
 ] 

ASF GitHub Bot commented on TAJO-2164:
--------------------------------------

GitHub user blrunner opened a pull request:

    https://github.com/apache/tajo/pull/1033

    TAJO-2164: SequenceFile print wrong values with TextSerializerDeserializer

    See https://issues.apache.org/jira/browse/TAJO-2164

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/blrunner/tajo TAJO-2164

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/tajo/pull/1033.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #1033
    
----
commit 697ce8cae14510bee11aecbefb5d0a1e01e00668
Author: JaeHwa Jung <[email protected]>
Date:   2016-05-27T08:18:18Z

    TAJO-2164: SequenceFile print wrong values with TextSerializerDeserializer

commit cf6051d0d31cf2c82d008064ed9e55c5259bc879
Author: JaeHwa Jung <[email protected]>
Date:   2016-05-27T08:21:52Z

    Add to get delimiter with text.delimiter

----


> 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)

Reply via email to