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)

Reply via email to