S_AcctBal decimal(13, 2) , S_Comment varchar(105) , skip varchar(64) ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LOCATION Make sure the tables have been loaded, e.g. they are in the tables list and all contain data. You can check they contain data by running the following queries (ONE BY ONE) (a plain text file is available at ) SELECT count(*) from region; SELECT count(*) from nation; SELECT count(*) from supplier; SELECT count(*) from customer; SELECT count(*) from part; SELECT count(*) from partsupp; SELECT count(*) from orders; SELECT count(*) from lineitem; Please note whether and if so how the execution times for running the SELECT COUNT(*) FROM table queries differ between RedShift & Athena. If they do, any idea why? Run the following queries Athena TPC-H Query 1 (a plain text file is available at ) SELECT L_RETURNFLAG, L_LINESTATUS, SUM(L_QUANTITY), SUM(L_EXTENDEDPRICE), SUM(L_EXTENDEDPRICE*(1-L_DISCOUNT)), SUM(L_EXTENDEDPRICE*(1-L_DISCOUNT)*(1+L_TAX)), AVG(L_QUANTITY), AVG(L_EXTENDEDPRICE), AVG(L_DISCOUNT), COUNT(1) FROM lineitem WHERE L_SHIPDATE<= CAST ('1998-09-02' AS DATE) GROUP BY L_RETURNFLAG, L_LINESTATUS ORDER BY L_RETURNFLAG, L_LINESTATUS; Athena TPC-H Query 5 (a plain text file is available at )
S_AcctBal decimal(13, 2) , S_Comment varchar(105) , skip varchar(64) ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LOCATION Make sure the tables have been loaded, e.g. they are in the tables list and all contain data. You can check they contain data by running the following queries (ONE BY ONE) (a plain text file is available at ) SELECT count(*) from region; SELECT count(*) from nation; SELECT count(*) from supplier; SELECT count(*) from customer; SELECT count(*) from part; SELECT count(*) from partsupp; SELECT count(*) from orders; SELECT count(*) from lineitem; Please note whether and if so how the execution times for running the SELECT COUNT(*) FROM table queries differ between RedShift & Athena. If they do, any idea why? Run the following queries Athena TPC-H Query 1 (a plain text file is available at ) SELECT L_RETURNFLAG, L_LINESTATUS, SUM(L_QUANTITY), SUM(L_EXTENDEDPRICE), SUM(L_EXTENDEDPRICE*(1-L_DISCOUNT)), SUM(L_EXTENDEDPRICE*(1-L_DISCOUNT)*(1+L_TAX)), AVG(L_QUANTITY), AVG(L_EXTENDEDPRICE), AVG(L_DISCOUNT), COUNT(1) FROM lineitem WHERE L_SHIPDATE<= CAST ('1998-09-02' AS DATE) GROUP BY L_RETURNFLAG, L_LINESTATUS ORDER BY L_RETURNFLAG, L_LINESTATUS; Athena TPC-H Query 5 (a plain text file is available at )
Hivevs.Redshift.docx