You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Selvaganesan Govindarajan (JIRA)" <ji...@apache.org> on 2016/10/05 14:18:20 UTC
[jira] [Commented] (TRAFODION-2239) TPC-H 100GB query08 returns
ERROR[8448]
[ https://issues.apache.org/jira/browse/TRAFODION-2239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15548839#comment-15548839 ]
Selvaganesan Govindarajan commented on TRAFODION-2239:
------------------------------------------------------
Can you please send the the plan of the query. To get the plan, you can do the following
log query1.log ;
showddl <table_name>
prepare s1 from <query_1> ;
explain options 'f' s1 ;
explain s1 ;
log ;
> TPC-H 100GB query08 returns ERROR[8448]
> ---------------------------------------
>
> Key: TRAFODION-2239
> URL: https://issues.apache.org/jira/browse/TRAFODION-2239
> Project: Apache Trafodion
> Issue Type: Bug
> Affects Versions: 2.0-incubating
> Reporter: Aaron Molitor
> Assignee: Selvaganesan Govindarajan
>
> executing TPC-H query08 results in the follwing error:
> {noformat}
> SQL>@08.sql
> SQL>SELECT
> +> O_YEAR,
> +> SUM(CASE
> +> WHEN NATION = 'BRAZIL'
> +> THEN VOLUME
> +> ELSE 0
> +> END) / SUM(VOLUME) AS MKT_SHARE
> +>FROM
> +> (
> +> SELECT
> +> YEAR(O_ORDERDATE) AS O_YEAR,
> +> L_EXTENDEDPRICE * (1 - L_DISCOUNT) AS VOLUME,
> +> N2.N_NAME AS NATION
> +> FROM
> +> TPCH.PART,
> +> TPCH.SUPPLIER,
> +> TPCH.LINEITEM,
> +> TPCH.ORDERS,
> +> TPCH.CUSTOMER,
> +> TPCH.NATION N1,
> +> TPCH.NATION N2,
> +> TPCH.REGION
> +> WHERE
> +> P_PARTKEY = L_PARTKEY
> +> AND S_SUPPKEY = L_SUPPKEY
> +> AND L_ORDERKEY = O_ORDERKEY
> +> AND O_CUSTKEY = C_CUSTKEY
> +> AND C_NATIONKEY = N1.N_NATIONKEY
> +> AND N1.N_REGIONKEY = R_REGIONKEY
> +> AND R_NAME = 'AMERICA'
> +> AND S_NATIONKEY = N2.N_NATIONKEY
> +> AND O_ORDERDATE BETWEEN TO_DATE('1995-01-01') AND TO_DATE('1996-12-31')
> +> AND P_TYPE = 'ECONOMY ANODIZED STEEL'
> +> ) AS ALL_NATIONS
> +>GROUP BY
> +> O_YEAR
> +>ORDER BY
> +> O_YEAR
> +>;
> *** ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::nextRow returned error HBASE_ACCESS_ERROR(-706). Cause:
> java.util.concurrent.ExecutionException: org.apache.hadoop.hbase.client.ScannerTimeoutException: 3112204ms passed since the last invocation, timeout is currently set to 60000
> java.util.concurrent.FutureTask.report(FutureTask.java:122)
> java.util.concurrent.FutureTask.get(FutureTask.java:188)
> org.trafodion.sql.HTableClient.fetchRows(HTableClient.java:1180)
> . [2016-09-23 02:22:38]
> SQL>
> {noformat}
> query statsitics are:
> {noformat}
> SQL>GET STATISTICS FOR QID MXID11004008700212341331081166350000000000206U3333300_544_SQL_CUR_4;
> Qid MXID11004008700212341331081166350000000000206U3333300_544_SQL_CUR_4
> Compile Start Time 2016/09/23 01:29:22.005216
> Compile End Time 2016/09/23 01:29:28.079747
> Compile Elapsed Time 0:00:06.074531
> Execute Start Time 2016/09/23 01:29:28.079973
> Execute End Time 2016/09/23 02:22:38.285287
> Execute Elapsed Time 0:53:10.205314
> State CLOSE
> Rows Affected 0
> SQL Error Code -8448
> Stats Error Code 0
> Query Type SQL_SELECT_NON_UNIQUE
> Sub Query Type SQL_STMT_NA
> Estimated Accessed Rows 0
> Estimated Used Rows 0
> Parent Qid NONE
> Parent Query System NONE
> Child Qid NONE
> Number of SQL Processes 119
> Number of Cpus 9
> Transaction Id -1
> Source String SELECT
> O_YEAR,
> SUM(CASE
> WHEN NATION = 'BRAZIL'
> THEN VOLUME
> ELSE 0
> END) / SUM(VOLUME) AS MKT_SHARE
> FROM
> (
> SELECT
> YEAR(O_ORDERDATE) AS O_YEAR,
> L_EXTENDEDPRICE * (1 - L_DISCOUNT) AS VOLUME,
>
> SQL Source Length 931
> Rows Returned 0
> First Row Returned Time -1
> Last Error before AQR 0
> Number of AQR retries 0
> Delay before AQR 0
> No. of times reclaimed 0
> Cancel Time -1
> Last Suspend Time -1
> Stats Collection Type OPERATOR_STATS
> SQL Process Busy Time 4,250,159,337
> UDR Process Busy Time 0
> SQL Space Allocated 124,372 KB
> SQL Space Used 121,696 KB
> SQL Heap Allocated 3,847 KB
> SQL Heap Used 1,307 KB
> EID Space Allocated 0 KB
> EID Space Used 0 KB
> EID Heap Allocated 0 KB
> EID Heap Used 0 KB
> Processes Created 31
> Process Create Time 458,952
> Request Message Count 911,633
> Request Message Bytes 148,754,704
> Reply Message Count 911,043
> Reply Message Bytes 27,442,403,584
> Scr. Overflow Mode MMAP
> Scr File Count 0
> Scr. Buffer Blk Size 0
> Scr. Buffer Blks Read 0
> Scr. Buffer Blks Written 0
> Scr. Read Count 0
> Scr. Write Count 0
>
> Table Name
> Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO
> Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
> TRAFODION.TPCH.NATION
> 0 25
> 25 25 16 0 1,160,170 189,331
> TRAFODION.TPCH.SUPPLIER
> 0 1,000,000
> 965,345 965,345 109 44 9,210,481 1,739,007
> TRAFODION.TPCH.REGION
> 0 1
> 5 1 16 0 79,082 14,932
> TRAFODION.TPCH.NATION
> 0 25
> 25 25 16 0 99,682 18,935
> TRAFODION.TPCH.CUSTOMER
> 0 15,000,000
> 12,106,188 12,106,188 1,224 554 158,448,315 27,384,195
> TRAFODION.TPCH.PART
> 0 138,629
> 20,000,000 134,258 2,012 1,232 281,687,301 39,273,394
> TRAFODION.TPCH.LINEITEM
> 0 600,037,888
> 300,209,401 300,209,401 30,036 39,509 8,378,655,613 2,256,566,856
> TRAFODION.TPCH.ORDERS
> 0 45,601,144
> 480,000 146,334 64 31 10,235,511 1,557,184
> --- SQL operation complete.
> SQL>
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)