You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Aaron Molitor (JIRA)" <ji...@apache.org> on 2016/09/23 02:54:20 UTC
[jira] [Created] (TRAFODION-2239) TPC-H 100GB query08 returns
ERROR[8448]
Aaron Molitor created TRAFODION-2239:
----------------------------------------
Summary: 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
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)