update the checking table
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/fc3bb5a7 Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/fc3bb5a7 Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/fc3bb5a7 Branch: refs/heads/master Commit: fc3bb5a7c744848bd1c81680b34d1fbbf31e225b Parents: 024e001 Author: Liu Ming <ovis_p...@sina.com> Authored: Tue Jul 12 09:02:10 2016 -0400 Committer: Liu Ming <ovis_p...@sina.com> Committed: Tue Jul 12 09:02:10 2016 -0400 ---------------------------------------------------------------------- core/sqf/sql/scripts/install_hadoop_regr_test_env | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/fc3bb5a7/core/sqf/sql/scripts/install_hadoop_regr_test_env ---------------------------------------------------------------------- diff --git a/core/sqf/sql/scripts/install_hadoop_regr_test_env b/core/sqf/sql/scripts/install_hadoop_regr_test_env index 0ddb2bd..6bec9e0 100755 --- a/core/sqf/sql/scripts/install_hadoop_regr_test_env +++ b/core/sqf/sql/scripts/install_hadoop_regr_test_env @@ -122,10 +122,10 @@ done # (or most recently added item) if [[ "$FORCE" != "true" ]] then - $MY_HIVE_CMD -e 'describe store_orc;' >/dev/null 2>&1 + $MY_HIVE_CMD -e 'describe ship_mode;' >/dev/null 2>&1 if (( $? == 0 )) then - echo "Hive table store_orc found. Skipping TPC-DS set-up." + echo "Hive table ship_mode found. Skipping TPC-DS set-up." exit 0 fi fi @@ -504,6 +504,7 @@ create external table customer_address row format delimited fields terminated by '|' location '/hive/tpcds/customer_address'; +create table store_orc stored as orc as select * from store; create external table store_returns ( @@ -840,8 +841,6 @@ create external table ship_mode row format delimited fields terminated by '|' location '/hive/tpcds/ship_mode'; -create table store_orc stored as orc as select * from store; - quit; EOF