Mailing-List: contact commits-help@trafodion.apache.org; run by ezmlm
Precedence: bulk
Reply-To: commits@trafodion.apache.org
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: sureshs@apache.org
To: commits@trafodion.incubator.apache.org
Date: Tue, 15 Sep 2015 15:39:26 -0000
Message-Id: <d3e3b1ec36f947c394058a06e244156c@git.apache.org>
Subject: [1/2] incubator-trafodion git commit: Fix for JIRA TRAFODION-1491 -
 HIVE TEST009 fails

Repository: incubator-trafodion
Updated Branches:
  refs/heads/master eeb018998 -> 96f50daa1


Fix for JIRA TRAFODION-1491 - HIVE TEST009 fails

The file TEST009_b.hive.sql was not checked into the GIT repository.
It is needed to successfully run TEST009.


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/d857ff5c
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/d857ff5c
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/d857ff5c

Branch: refs/heads/master
Commit: d857ff5c6ad6b4dd51ac4ee7953514f158dc7705
Parents: 324ab95
Author: Roberta Marton <roberta.marton@esgyn.com>
Authored: Mon Sep 14 16:18:55 2015 +0000
Committer: Roberta Marton <roberta.marton@esgyn.com>
Committed: Mon Sep 14 16:18:55 2015 +0000

----------------------------------------------------------------------
 core/sql/regress/hive/TEST009_b.hive.sql | 48 +++++++++++++++++++++++++++
 1 file changed, 48 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d857ff5c/core/sql/regress/hive/TEST009_b.hive.sql
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/TEST009_b.hive.sql b/core/sql/regress/hive/TEST009_b.hive.sql
new file mode 100644
index 0000000..a27994f
--- /dev/null
+++ b/core/sql/regress/hive/TEST009_b.hive.sql
@@ -0,0 +1,48 @@
+-- @@@ START COPYRIGHT @@@
+--  Licensed under the Apache License, Version 2.0 (the "License");
+--  you may not use this file except in compliance with the License.
+--  You may obtain a copy of the License at
+--
+--      http://www.apache.org/licenses/LICENSE-2.0
+--
+--  Unless required by applicable law or agreed to in writing, software
+--  distributed under the License is distributed on an "AS IS" BASIS,
+--  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+--  See the License for the specific language governing permissions and
+--  limitations under the License.
+--
+-- @@@ END COPYRIGHT @@@
+
+-- ============================================================================
+-- All tables are created as EXTERNAL in a location already setup by 
+-- install_local_hadoop. The EXTERNAL keyword lets you create a table and 
+-- provide a LOCATION so that Hive does not use the default location 
+-- specified by the configuration property hive.metastore.warehouse.dir.
+-- ============================================================================
+
+-- Our version of HIVE does not support special characters.  This test should 
+-- be changed to use delimited names once we upgrade HIVE.
+
+create schema if not exists sch_t009;
+use sch_t009;
+drop table t009t1;
+create external table t009t1
+(
+    a int,
+    b int, 
+    c int,
+    d int
+)
+row format delimited fields terminated by '|'
+location '/user/hive/exttables/t009t1';
+
+-- Our version of HIVE does not support insert ... VALUES clause, so use the
+-- load command from an existing table.
+insert into table t009t1
+select c_customer_sk, c_birth_day, c_birth_month, c_birth_year
+from default.customer
+limit 10;
+
+select * from t009t1;
+
+