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 2016/01/08 08:13:39 UTC

[jira] [Created] (TAJO-2047) Query hangs occasionally while executing CTAS for partition table on aws

Jaehwa Jung created TAJO-2047:
---------------------------------

             Summary: Query hangs occasionally while executing CTAS for partition table on aws
                 Key: TAJO-2047
                 URL: https://issues.apache.org/jira/browse/TAJO-2047
             Project: Tajo
          Issue Type: Sub-task
            Reporter: Jaehwa Jung
            Assignee: Jaehwa Jung


Query hangs while executing CTAS for partition table on aws as following:
* Root directory exists on s3
* Dataset : tpc-h 1G
* Query
{code:xml}
CREATE TABLE LINEITEM_P (L_ORDERKEY bigint, L_PARTKEY bigint, L_SUPPKEY bigint, L_LINENUMBER bigint, L_QUANTITY double, L_EXTENDEDPRICE double, L_DISCOUNT double, L_TAX double, L_RETURNFLAG text, L_LINESTATUS text, L_COMMITDATE text, L_RECEIPTDATE text, L_SHIPINSTRUCT text, L_SHIPMODE text, L_COMMENT text) 
USING TEXT WITH ('text.delimiter'='|')
PARTITION BY COLUMN (L_SHIPDATE text) AS 
SELECT L_ORDERKEY, L_PARTKEY, L_SUPPKEY, L_LINENUMBER, L_QUANTITY, L_EXTENDEDPRICE, L_DISCOUNT, L_TAX, L_RETURNFLAG, L_LINESTATUS, L_COMMITDATE, L_RECEIPTDATE, L_SHIPINSTRUCT, L_SHIPMODE, L_COMMENT, L_SHIPDATE FROM LINEITEM;
{code}

I see that the progress percentage is 100 percent and query doesn't finish.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)