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)