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)

Reply via email to