You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by pa...@apache.org on 2011/03/15 21:29:05 UTC
svn commit: r1081930 [2/5] - in /hive/trunk:
common/src/java/org/apache/hadoop/hive/conf/ conf/
ql/src/java/org/apache/hadoop/hive/ql/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/metadata/ ql/src/java/org/apache/ha...
Added: hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/parse/TestEximUtil.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/parse/TestEximUtil.java?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/parse/TestEximUtil.java (added)
+++ hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/parse/TestEximUtil.java Tue Mar 15 20:29:02 2011
@@ -0,0 +1,112 @@
+/**
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you 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.
+ */
+
+package org.apache.hadoop.hive.ql.parse;
+
+import junit.framework.TestCase;
+
+/**
+ * TestEximUtil.
+ *
+ */
+public class TestEximUtil extends TestCase {
+
+ @Override
+ protected void setUp() {
+ }
+
+ @Override
+ protected void tearDown() {
+ }
+
+ public void testCheckCompatibility() throws SemanticException {
+
+ // backward/forward compatible
+ EximUtil.doCheckCompatibility(
+ "10.3", // current code version
+ "10.4", // data's version
+ null // data's FC version
+ ); // No exceptions expected
+ EximUtil.doCheckCompatibility(
+ "10.4", // current code version
+ "10.4", // data's version
+ null // data's FC version
+ ); // No exceptions expected
+ EximUtil.doCheckCompatibility(
+ "10.5", // current code version
+ "10.4", // data's version
+ null // data's FC version
+ ); // No exceptions expected
+
+ // not backward compatible
+ try {
+ EximUtil.doCheckCompatibility(
+ "11.0", // current code version
+ "10.4", // data's version
+ null // data's FC version
+ ); // No exceptions expected
+ fail();
+ } catch (SemanticException e) {
+ }
+
+ // not forward compatible
+ try {
+ EximUtil.doCheckCompatibility(
+ "9.9", // current code version
+ "10.4", // data's version
+ null // data's FC version
+ ); // No exceptions expected
+ fail();
+ } catch (SemanticException e) {
+ }
+
+ // forward compatible
+ EximUtil.doCheckCompatibility(
+ "9.9", // current code version
+ "10.4", // data's version
+ "9.9" // data's FC version
+ ); // No exceptions expected
+ EximUtil.doCheckCompatibility(
+ "9.9", // current code version
+ "10.4", // data's version
+ "9.8" // data's FC version
+ ); // No exceptions expected
+ EximUtil.doCheckCompatibility(
+ "9.9", // current code version
+ "10.4", // data's version
+ "8.8" // data's FC version
+ ); // No exceptions expected
+ EximUtil.doCheckCompatibility(
+ "10.3", // current code version
+ "10.4", // data's version
+ "10.3" // data's FC version
+ ); // No exceptions expected
+
+ // not forward compatible
+ try {
+ EximUtil.doCheckCompatibility(
+ "10.2", // current code version
+ "10.4", // data's version
+ "10.3" // data's FC version
+ ); // No exceptions expected
+ fail();
+ } catch (SemanticException e) {
+ }
+
+ }
+}
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_00_unsupported_schema.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_00_unsupported_schema.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_00_unsupported_schema.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_00_unsupported_schema.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,11 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'nosuchschema://nosuchauthority/ql/test/data/exports/exim_department';
+drop table exim_department;
+
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_01_nonpart_over_loaded.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_01_nonpart_over_loaded.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_01_nonpart_over_loaded.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_01_nonpart_over_loaded.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,23 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_id int comment "department identifier")
+ stored as textfile
+ tblproperties("maker"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+import from 'ql/test/data/exports/exim_department';
+drop table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_02_all_part_over_overlap.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_02_all_part_over_overlap.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_02_all_part_over_overlap.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_02_all_part_over_overlap.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,37 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="ka");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="ka");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "table of employees"
+ partitioned by (emp_country string comment "iso code", emp_state string comment "free-form text")
+ stored as textfile
+ tblproperties("maker"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="ka");
+import from 'ql/test/data/exports/exim_employee';
+describe extended exim_employee;
+select * from exim_employee;
+drop table exim_employee;
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_03_nonpart_noncompat_colschema.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_03_nonpart_noncompat_colschema.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_03_nonpart_noncompat_colschema.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_03_nonpart_noncompat_colschema.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,22 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_key int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+import from 'ql/test/data/exports/exim_department';
+drop table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_04_nonpart_noncompat_colnumber.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_04_nonpart_noncompat_colnumber.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_04_nonpart_noncompat_colnumber.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_04_nonpart_noncompat_colnumber.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,22 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_id int comment "department id", dep_name string)
+ stored as textfile
+ tblproperties("creator"="krishna");
+import from 'ql/test/data/exports/exim_department';
+drop table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_05_nonpart_noncompat_coltype.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_05_nonpart_noncompat_coltype.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_05_nonpart_noncompat_coltype.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_05_nonpart_noncompat_coltype.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,22 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_id bigint comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+import from 'ql/test/data/exports/exim_department';
+drop table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_06_nonpart_noncompat_storage.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_06_nonpart_noncompat_storage.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_06_nonpart_noncompat_storage.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_06_nonpart_noncompat_storage.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,22 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as rcfile
+ tblproperties("creator"="krishna");
+import from 'ql/test/data/exports/exim_department';
+drop table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_07_nonpart_noncompat_ifof.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_07_nonpart_noncompat_ifof.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_07_nonpart_noncompat_ifof.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_07_nonpart_noncompat_ifof.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,25 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as inputformat "org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat"
+ outputformat "org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat"
+ inputdriver "org.apache.hadoop.hive.howl.rcfile.RCFileInputDriver"
+ outputdriver "org.apache.hadoop.hive.howl.rcfile.RCFileOutputDriver"
+ tblproperties("creator"="krishna");
+import from 'ql/test/data/exports/exim_department';
+drop table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_08_nonpart_noncompat_serde.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_08_nonpart_noncompat_serde.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_08_nonpart_noncompat_serde.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_08_nonpart_noncompat_serde.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,23 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_id int comment "department id")
+ row format serde "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe"
+ stored as textfile
+ tblproperties("creator"="krishna");
+import from 'ql/test/data/exports/exim_department';
+drop table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_09_nonpart_noncompat_serdeparam.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_09_nonpart_noncompat_serdeparam.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_09_nonpart_noncompat_serdeparam.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_09_nonpart_noncompat_serdeparam.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,27 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_id int comment "department id")
+ row format serde "org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"
+ with serdeproperties ("serialization.format"="0")
+ stored as inputformat "org.apache.hadoop.mapred.TextInputFormat"
+ outputformat "org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat"
+ inputdriver "org.apache.hadoop.hive.howl.rcfile.RCFileInputDriver"
+ outputdriver "org.apache.hadoop.hive.howl.rcfile.RCFileOutputDriver"
+ tblproperties("creator"="krishna");
+import from 'ql/test/data/exports/exim_department';
+drop table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_10_nonpart_noncompat_bucketing.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_10_nonpart_noncompat_bucketing.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_10_nonpart_noncompat_bucketing.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_10_nonpart_noncompat_bucketing.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,23 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_id int comment "department id")
+ clustered by (dep_id) into 10 buckets
+ stored as textfile
+ tblproperties("creator"="krishna");
+import from 'ql/test/data/exports/exim_department';
+drop table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_11_nonpart_noncompat_sorting.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_11_nonpart_noncompat_sorting.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_11_nonpart_noncompat_sorting.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_11_nonpart_noncompat_sorting.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,24 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ clustered by (dep_id) sorted by (dep_id desc) into 10 buckets
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_id int comment "department id")
+ clustered by (dep_id) sorted by (dep_id asc) into 10 buckets
+ stored as textfile
+ tblproperties("creator"="krishna");
+import from 'ql/test/data/exports/exim_department';
+drop table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_12_nonnative_export.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_12_nonnative_export.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_12_nonnative_export.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_12_nonnative_export.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,9 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ clustered by (dep_id) sorted by (dep_id desc) into 10 buckets
+ stored by "org.apache.hadoop.hive.ql.metadata.DefaultStorageHandler"
+ tblproperties("creator"="krishna");
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
\ No newline at end of file
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_13_nonnative_import.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_13_nonnative_import.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_13_nonnative_import.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_13_nonnative_import.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,23 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_id int comment "department id")
+ stored by "org.apache.hadoop.hive.ql.metadata.DefaultStorageHandler"
+ tblproperties("creator"="krishna");
+import from 'ql/test/data/exports/exim_department';
+drop table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
+drop database importer;
+
\ No newline at end of file
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_14_nonpart_part.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_14_nonpart_part.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_14_nonpart_part.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_14_nonpart_part.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,24 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_id int comment "department id")
+ partitioned by (dep_org string)
+ stored as textfile
+ tblproperties("creator"="krishna");
+import from 'ql/test/data/exports/exim_department';
+drop table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
+drop database importer;
+
\ No newline at end of file
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_15_part_nonpart.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_15_part_nonpart.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_15_part_nonpart.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_15_part_nonpart.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,24 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ partitioned by (dep_org string)
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department partition (dep_org="hr");
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+import from 'ql/test/data/exports/exim_department';
+drop table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
+drop database importer;
+
\ No newline at end of file
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_16_part_noncompat_schema.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_16_part_noncompat_schema.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_16_part_noncompat_schema.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_16_part_noncompat_schema.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,25 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ partitioned by (dep_org string)
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department partition (dep_org="hr");
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_id int comment "department id")
+ partitioned by (dep_mgr string)
+ stored as textfile
+ tblproperties("creator"="krishna");
+import from 'ql/test/data/exports/exim_department';
+drop table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
+drop database importer;
+
\ No newline at end of file
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_17_part_spec_underspec.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_17_part_spec_underspec.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_17_part_spec_underspec.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_17_part_spec_underspec.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,29 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="ka");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="ka");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+import table exim_employee partition (emp_country="us") from 'ql/test/data/exports/exim_employee';
+describe extended exim_employee;
+select * from exim_employee;
+drop table exim_employee;
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_18_part_spec_missing.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_18_part_spec_missing.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_18_part_spec_missing.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_18_part_spec_missing.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,29 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="ka");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="ka");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+import table exim_employee partition (emp_country="us", emp_state="kl") from 'ql/test/data/exports/exim_employee';
+describe extended exim_employee;
+select * from exim_employee;
+drop table exim_employee;
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_19_external_over_existing.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_19_external_over_existing.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_19_external_over_existing.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_19_external_over_existing.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,22 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+import external table exim_department from 'ql/test/data/exports/exim_department';
+!rm -rf ../build/ql/test/data/exports/exim_department;
+drop table exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_20_managed_location_over_existing.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_20_managed_location_over_existing.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_20_managed_location_over_existing.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_20_managed_location_over_existing.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,28 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+!rm -rf ../build/ql/test/data/tablestore/exim_department;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ location 'ql/test/data/tablestore/exim_department'
+ tblproperties("creator"="krishna");
+import table exim_department from 'ql/test/data/exports/exim_department'
+ location 'ql/test/data/tablestore2/exim_department';
+!rm -rf ../build/ql/test/data/exports/exim_department;
+drop table exim_department;
+
+!rm -rf ../build/ql/test/data/tablestore/exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_21_part_managed_external.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_21_part_managed_external.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_21_part_managed_external.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_21_part_managed_external.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,34 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="ka");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="ka");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+import external table exim_employee partition (emp_country="us", emp_state="tn")
+ from 'ql/test/data/exports/exim_employee';
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+drop table exim_employee;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_22_export_authfail.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_22_export_authfail.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_22_export_authfail.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_22_export_authfail.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,13 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int) stored as textfile;
+
+set hive.security.authorization.enabled=true;
+
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+
+set hive.security.authorization.enabled=false;
+drop table exim_department;
+
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_23_import_exist_authfail.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_23_import_exist_authfail.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_23_import_exist_authfail.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_23_import_exist_authfail.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,21 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int) stored as textfile;
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_id int) stored as textfile;
+set hive.security.authorization.enabled=true;
+import from 'ql/test/data/exports/exim_department';
+
+set hive.security.authorization.enabled=false;
+drop table exim_department;
+drop database importer;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_24_import_part_authfail.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_24_import_part_authfail.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_24_import_part_authfail.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_24_import_part_authfail.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,30 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+
+set hive.security.authorization.enabled=true;
+import from 'ql/test/data/exports/exim_employee';
+set hive.security.authorization.enabled=false;
+
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+drop table exim_employee;
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientnegative/exim_25_import_nonexist_authfail.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exim_25_import_nonexist_authfail.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientnegative/exim_25_import_nonexist_authfail.q (added)
+++ hive/trunk/ql/src/test/queries/clientnegative/exim_25_import_nonexist_authfail.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,22 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_department ( dep_id int) stored as textfile;
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+set hive.security.authorization.enabled=true;
+import from 'ql/test/data/exports/exim_department';
+
+set hive.security.authorization.enabled=false;
+select * from exim_department;
+drop table exim_department;
+drop database importer;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_00_nonpart_empty.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_00_nonpart_empty.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_00_nonpart_empty.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_00_nonpart_empty.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,22 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+import from 'ql/test/data/exports/exim_department';
+describe extended exim_department;
+show table extended like exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+select * from exim_department;
+drop table exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_01_nonpart.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_01_nonpart.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_01_nonpart.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_01_nonpart.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,23 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+import from 'ql/test/data/exports/exim_department';
+describe extended exim_department;
+show table extended like exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+select * from exim_department;
+drop table exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_02_00_part_empty.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_02_00_part_empty.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_02_00_part_empty.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_02_00_part_empty.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,24 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+
+import from 'ql/test/data/exports/exim_employee';
+describe extended exim_employee;
+show table extended like exim_employee;
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+select * from exim_employee;
+drop table exim_employee;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_02_part.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_02_part.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_02_part.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_02_part.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,26 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+
+import from 'ql/test/data/exports/exim_employee';
+describe extended exim_employee;
+show table extended like exim_employee;
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+select * from exim_employee;
+drop table exim_employee;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_03_nonpart_over_compat.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_03_nonpart_over_compat.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_03_nonpart_over_compat.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_03_nonpart_over_compat.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,25 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_id int comment "department identifier")
+ stored as textfile
+ tblproperties("maker"="krishna");
+import from 'ql/test/data/exports/exim_department';
+describe extended exim_department;
+select * from exim_department;
+drop table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_04_all_part.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_04_all_part.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_04_all_part.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_04_all_part.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,32 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="ka");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="ka");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+
+import from 'ql/test/data/exports/exim_employee';
+describe extended exim_employee;
+show table extended like exim_employee;
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+select * from exim_employee;
+drop table exim_employee;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_04_evolved_parts.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_04_evolved_parts.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_04_evolved_parts.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_04_evolved_parts.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,39 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_employee (emp_id int comment 'employee id', emp_name string, emp_dob string comment 'employee date of birth', emp_sex string comment 'M/F')
+ comment 'employee table'
+ partitioned by (emp_country string comment '2-char code', emp_state string comment '2-char code')
+ clustered by (emp_sex) sorted by (emp_id ASC) into 10 buckets
+ row format serde "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" with serdeproperties ('serialization.format'='1')
+ stored as rcfile;
+
+alter table exim_employee add partition (emp_country='in', emp_state='tn');
+
+alter table exim_employee add columns (emp_dept int);
+alter table exim_employee set serde "org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe" with serdeproperties ('serialization.format'='2');
+alter table exim_employee set fileformat
+ inputformat "org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat"
+ outputformat "org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat";
+alter table exim_employee clustered by (emp_sex, emp_dept) sorted by (emp_id desc) into 5 buckets;
+
+alter table exim_employee add partition (emp_country='in', emp_state='ka');
+
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+
+import from 'ql/test/data/exports/exim_employee';
+describe extended exim_employee;
+describe extended exim_employee partition (emp_country='in', emp_state='tn');
+describe extended exim_employee partition (emp_country='in', emp_state='ka');
+show table extended like exim_employee;
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+select * from exim_employee;
+drop table exim_employee;
+
+drop database importer;
\ No newline at end of file
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_05_some_part.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_05_some_part.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_05_some_part.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_05_some_part.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,32 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="ka");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="ka");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee partition (emp_state="ka") to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+
+import from 'ql/test/data/exports/exim_employee';
+describe extended exim_employee;
+show table extended like exim_employee;
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+select * from exim_employee;
+drop table exim_employee;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_06_one_part.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_06_one_part.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_06_one_part.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_06_one_part.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,32 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="ka");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="ka");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee partition (emp_country="in",emp_state="ka") to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+
+import from 'ql/test/data/exports/exim_employee';
+describe extended exim_employee;
+show table extended like exim_employee;
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+select * from exim_employee;
+drop table exim_employee;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_07_all_part_over_nonoverlap.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_07_all_part_over_nonoverlap.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_07_all_part_over_nonoverlap.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_07_all_part_over_nonoverlap.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,38 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="ka");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="ka");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "table of employees"
+ partitioned by (emp_country string comment "iso code", emp_state string comment "free-form text")
+ stored as textfile
+ tblproperties("maker"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="al");
+import from 'ql/test/data/exports/exim_employee';
+describe extended exim_employee;
+select * from exim_employee;
+drop table exim_employee;
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_08_nonpart_rename.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_08_nonpart_rename.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_08_nonpart_rename.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_08_nonpart_rename.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,27 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee,exim_imported_dept;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+create table exim_department ( dep_id int comment "department id")
+ partitioned by (emp_org string)
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department partition (emp_org="hr");
+import table exim_imported_dept from 'ql/test/data/exports/exim_department';
+describe extended exim_imported_dept;
+select * from exim_imported_dept;
+drop table exim_imported_dept;
+drop table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_09_part_spec_nonoverlap.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_09_part_spec_nonoverlap.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_09_part_spec_nonoverlap.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_09_part_spec_nonoverlap.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,39 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="ka");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="ka");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="ka");
+import table exim_employee partition (emp_country="us", emp_state="tn") from 'ql/test/data/exports/exim_employee';
+describe extended exim_employee;
+select * from exim_employee;
+drop table exim_employee;
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_10_external_managed.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_10_external_managed.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_10_external_managed.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_10_external_managed.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,25 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+!rm -rf ../build/ql/test/data/tablestore/exim_department;
+create external table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ location 'ql/test/data/tablestore/exim_department'
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+!rm -rf ../build/ql/test/data/tablestore/exim_department;
+
+create database importer;
+use importer;
+
+import from 'ql/test/data/exports/exim_department';
+describe extended exim_department;
+select * from exim_department;
+drop table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_11_managed_external.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_11_managed_external.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_11_managed_external.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_11_managed_external.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,23 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+import external table exim_department from 'ql/test/data/exports/exim_department';
+describe extended exim_department;
+select * from exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+select * from exim_department;
+drop table exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_12_external_location.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_12_external_location.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_12_external_location.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_12_external_location.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,27 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+!rm -rf ../build/ql/test/data/tablestore/exim_department;
+
+import external table exim_department from 'ql/test/data/exports/exim_department'
+ location 'ql/test/data/tablestore/exim_department';
+describe extended exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+select * from exim_department;
+!rm -rf ../build/ql/test/data/tablestore/exim_department;
+select * from exim_department;
+drop table exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_13_managed_location.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_13_managed_location.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_13_managed_location.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_13_managed_location.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,27 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+!rm -rf ../build/ql/test/data/tablestore/exim_department;
+
+import table exim_department from 'ql/test/data/exports/exim_department'
+ location 'ql/test/data/tablestore/exim_department';
+describe extended exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+select * from exim_department;
+!rm -rf ../build/ql/test/data/tablestore/exim_department;
+select * from exim_department;
+drop table exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_14_managed_location_over_existing.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_14_managed_location_over_existing.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_14_managed_location_over_existing.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_14_managed_location_over_existing.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,31 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+!rm -rf ../build/ql/test/data/tablestore/exim_department;
+
+create table exim_department ( dep_id int comment "department id")
+ stored as textfile
+ location 'ql/test/data/tablestore/exim_department'
+ tblproperties("creator"="krishna");
+import table exim_department from 'ql/test/data/exports/exim_department'
+ location 'ql/test/data/tablestore/exim_department';
+describe extended exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+select * from exim_department;
+!rm -rf ../build/ql/test/data/tablestore/exim_department;
+select * from exim_department;
+drop table exim_department;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_15_external_part.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_15_external_part.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_15_external_part.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_15_external_part.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,48 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="ka");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="ka");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+
+!rm -rf ../build/ql/test/data/tablestore/exim_employee;
+
+create external table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ location 'ql/test/data/tablestore/exim_employee'
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="ka");
+import external table exim_employee partition (emp_country="us", emp_state="tn")
+ from 'ql/test/data/exports/exim_employee';
+describe extended exim_employee;
+select * from exim_employee;
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+select * from exim_employee;
+!rm -rf ../build/ql/test/data/tablestore/exim_employee;
+select * from exim_employee;
+drop table exim_employee;
+
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_16_part_external.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_16_part_external.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_16_part_external.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_16_part_external.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,46 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="ka");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="ka");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+
+!rm -rf ../build/ql/test/data/tablestore/exim_employee;
+!rm -rf ../build/ql/test/data/tablestore2/exim_employee;
+
+create external table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ location 'ql/test/data/tablestore2/exim_employee'
+ tblproperties("creator"="krishna");
+import table exim_employee partition (emp_country="us", emp_state="tn")
+ from 'ql/test/data/exports/exim_employee'
+ location 'ql/test/data/tablestore/exim_employee';
+show table extended like exim_employee;
+show table extended like exim_employee partition (emp_country="us", emp_state="tn");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+select * from exim_employee;
+!rm -rf ../build/ql/test/data/tablestore/exim_employee;
+select * from exim_employee;
+drop table exim_employee;
+!rm -rf ../build/ql/test/data/tablestore2/exim_employee;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_17_part_managed.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_17_part_managed.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_17_part_managed.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_17_part_managed.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,46 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="ka");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="ka");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+
+!rm -rf ../build/ql/test/data/tablestore/exim_employee;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+import table exim_employee partition (emp_country="us", emp_state="tn")
+ from 'ql/test/data/exports/exim_employee'
+ location 'ql/test/data/tablestore/exim_employee';
+alter table exim_employee add partition (emp_country="us", emp_state="ap")
+ location 'ql/test/data/tablestore2/exim_employee';
+show table extended like exim_employee;
+show table extended like exim_employee partition (emp_country="us", emp_state="tn");
+show table extended like exim_employee partition (emp_country="us", emp_state="ap");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+select * from exim_employee;
+!rm -rf ../build/ql/test/data/tablestore/exim_employee;
+select * from exim_employee;
+drop table exim_employee;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_18_part_external.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_18_part_external.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_18_part_external.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_18_part_external.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,35 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="ka");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="ka");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+
+import external table exim_employee partition (emp_country="us", emp_state="tn")
+ from 'ql/test/data/exports/exim_employee';
+describe extended exim_employee;
+show table extended like exim_employee;
+show table extended like exim_employee partition (emp_country="us", emp_state="tn");
+select * from exim_employee;
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+select * from exim_employee;
+drop table exim_employee;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_19_part_external_location.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_19_part_external_location.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_19_part_external_location.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_19_part_external_location.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,39 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="ka");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="ka");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+
+!rm -rf ../build/ql/test/data/tablestore/exim_employee;
+
+import external table exim_employee partition (emp_country="us", emp_state="tn")
+ from 'ql/test/data/exports/exim_employee'
+ location 'ql/test/data/tablestore/exim_employee';
+describe extended exim_employee;
+show table extended like exim_employee;
+show table extended like exim_employee partition (emp_country="us", emp_state="tn");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+select * from exim_employee;
+!rm -rf ../build/ql/test/data/tablestore/exim_employee;
+select * from exim_employee;
+drop table exim_employee;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_20_part_managed_location.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_20_part_managed_location.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_20_part_managed_location.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_20_part_managed_location.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,39 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="ka");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="tn");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="us", emp_state="ka");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+
+!rm -rf ../build/ql/test/data/tablestore/exim_employee;
+
+import table exim_employee partition (emp_country="us", emp_state="tn")
+ from 'ql/test/data/exports/exim_employee'
+ location 'ql/test/data/tablestore/exim_employee';
+describe extended exim_employee;
+show table extended like exim_employee;
+show table extended like exim_employee partition (emp_country="us", emp_state="tn");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+select * from exim_employee;
+!rm -rf ../build/ql/test/data/tablestore/exim_employee;
+select * from exim_employee;
+drop table exim_employee;
+
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_21_export_authsuccess.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_21_export_authsuccess.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_21_export_authsuccess.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_21_export_authsuccess.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,14 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+
+create table exim_department ( dep_id int) stored as textfile;
+load data local inpath "../data/files/test.dat" into table exim_department;
+
+set hive.security.authorization.enabled=true;
+
+grant Select on table exim_department to user hive_test_user;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+
+set hive.security.authorization.enabled=false;
+drop table exim_department;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_22_import_exist_authsuccess.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_22_import_exist_authsuccess.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_22_import_exist_authsuccess.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_22_import_exist_authsuccess.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,25 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_department ( dep_id int) stored as textfile;
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+create table exim_department ( dep_id int) stored as textfile;
+set hive.security.authorization.enabled=true;
+grant Alter on table exim_department to user hive_test_user;
+grant Update on table exim_department to user hive_test_user;
+import from 'ql/test/data/exports/exim_department';
+
+set hive.security.authorization.enabled=false;
+select * from exim_department;
+drop table exim_department;
+drop database importer;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_23_import_part_authsuccess.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_23_import_part_authsuccess.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_23_import_part_authsuccess.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_23_import_part_authsuccess.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,33 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+load data local inpath "../data/files/test.dat"
+ into table exim_employee partition (emp_country="in", emp_state="tn");
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+export table exim_employee to 'ql/test/data/exports/exim_employee';
+drop table exim_employee;
+
+create database importer;
+use importer;
+create table exim_employee ( emp_id int comment "employee id")
+ comment "employee table"
+ partitioned by (emp_country string comment "two char iso code", emp_state string comment "free text")
+ stored as textfile
+ tblproperties("creator"="krishna");
+
+set hive.security.authorization.enabled=true;
+grant Alter on table exim_employee to user hive_test_user;
+grant Update on table exim_employee to user hive_test_user;
+import from 'ql/test/data/exports/exim_employee';
+
+set hive.security.authorization.enabled=false;
+select * from exim_employee;
+!rm -rf ../build/ql/test/data/exports/exim_employee;
+drop table exim_employee;
+drop database importer;
Added: hive/trunk/ql/src/test/queries/clientpositive/exim_24_import_nonexist_authsuccess.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exim_24_import_nonexist_authsuccess.q?rev=1081930&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/exim_24_import_nonexist_authsuccess.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/exim_24_import_nonexist_authsuccess.q Tue Mar 15 20:29:02 2011
@@ -0,0 +1,23 @@
+set hive.test.mode=true;
+set hive.test.mode.prefix=;
+set hive.test.mode.nosamplelist=exim_department,exim_employee;
+
+create table exim_department ( dep_id int) stored as textfile;
+load data local inpath "../data/files/test.dat" into table exim_department;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+export table exim_department to 'ql/test/data/exports/exim_department';
+drop table exim_department;
+
+create database importer;
+use importer;
+
+set hive.security.authorization.enabled=true;
+grant Create on database importer to user hive_test_user;
+import from 'ql/test/data/exports/exim_department';
+
+set hive.security.authorization.enabled=false;
+select * from exim_department;
+drop table exim_department;
+drop database importer;
+!rm -rf ../build/ql/test/data/exports/exim_department;
+