Repository: hive Updated Branches: refs/heads/master adca6875c -> 882a7f000
http://git-wip-us.apache.org/repos/asf/hive/blob/882a7f00/ql/src/test/results/clientpositive/create_with_constraints.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/create_with_constraints.q.out b/ql/src/test/results/clientpositive/create_with_constraints.q.out index 7a7a50a..34dac30 100644 --- a/ql/src/test/results/clientpositive/create_with_constraints.q.out +++ b/ql/src/test/results/clientpositive/create_with_constraints.q.out @@ -92,6 +92,620 @@ foreign key (c) references table4(x) disable novalidate) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@table11 +PREHOOK: query: DESCRIBE EXTENDED table1 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table1 +POSTHOOK: query: DESCRIBE EXTENDED table1 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table1 +a string +b string + +#### A masked pattern was here #### +Constraints Primary Key for default.table1:[a], Constraint Name: #### A masked pattern was here #### +PREHOOK: query: DESCRIBE EXTENDED table2 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table2 +POSTHOOK: query: DESCRIBE EXTENDED table2 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table2 +a string +b string + +#### A masked pattern was here #### +Constraints Primary Key for default.table2:[a], Constraint Name: pk1 +PREHOOK: query: DESCRIBE EXTENDED table3 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table3 +POSTHOOK: query: DESCRIBE EXTENDED table3 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table3 +x string + +#### A masked pattern was here #### +Constraints Primary Key for default.table3:[x], Constraint Name: #### A masked pattern was here #### +PREHOOK: query: DESCRIBE EXTENDED table4 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table4 +POSTHOOK: query: DESCRIBE EXTENDED table4 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table4 +x string +y string + +#### A masked pattern was here #### +Constraints Primary Key for default.table4:[x], Constraint Name: #### A masked pattern was here #### +Foreign Keys for default.table4:[ {Constraint Name: fk3, (Parent Column Name: default.table2.a, Column Name: y, Key Sequence: 1)}] +PREHOOK: query: DESCRIBE EXTENDED table5 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table5 +POSTHOOK: query: DESCRIBE EXTENDED table5 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table5 +x string + +#### A masked pattern was here #### +Constraints Primary Key for default.table5:[x], Constraint Name: #### A masked pattern was here #### +PREHOOK: query: DESCRIBE EXTENDED table6 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table6 +POSTHOOK: query: DESCRIBE EXTENDED table6 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table6 +x string +y string + +#### A masked pattern was here #### +Constraints Primary Key for default.table6:[x], Constraint Name: #### A masked pattern was here #### +Foreign Keys for default.table6:[ {Constraint Name: fk4, (Parent Column Name: default.table1.a, Column Name: y, Key Sequence: 1)}] +PREHOOK: query: DESCRIBE EXTENDED table7 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table7 +POSTHOOK: query: DESCRIBE EXTENDED table7 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table7 +a string +b string + +#### A masked pattern was here #### +Constraints Primary Key for default.table7:[a], Constraint Name: #### A masked pattern was here #### +PREHOOK: query: DESCRIBE EXTENDED table8 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table8 +POSTHOOK: query: DESCRIBE EXTENDED table8 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table8 +a string +b string + +#### A masked pattern was here #### +Constraints Primary Key for default.table8:[a], Constraint Name: pk8 +PREHOOK: query: DESCRIBE EXTENDED table9 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table9 +POSTHOOK: query: DESCRIBE EXTENDED table9 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table9 +a string +b string + +#### A masked pattern was here #### +Constraints Primary Key for default.table9:[a,b], Constraint Name: #### A masked pattern was here #### +PREHOOK: query: DESCRIBE EXTENDED table10 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table10 +POSTHOOK: query: DESCRIBE EXTENDED table10 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table10 +a string +b string + +#### A masked pattern was here #### +Constraints Primary Key for default.table10:[a], Constraint Name: pk10 +Foreign Keys for default.table10:[ {Constraint Name: #### A masked pattern was here ####, (Parent Column Name: default.table9.a, Column Name: a, Key Sequence: 1), (Parent Column Name: default.table9.b, Column Name: b, Key Sequence: 2)}] +PREHOOK: query: DESCRIBE EXTENDED table11 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table11 +POSTHOOK: query: DESCRIBE EXTENDED table11 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table11 +a string +b string +c string + +#### A masked pattern was here #### +Constraints Primary Key for default.table11:[a], Constraint Name: pk11 +Foreign Keys for default.table11:[ {Constraint Name: #### A masked pattern was here ####, (Parent Column Name: default.table9.a, Column Name: a, Key Sequence: 1), (Parent Column Name: default.table9.b, Column Name: b, Key Sequence: 2)}, {Constraint Name: #### A masked pattern was here ####, (Parent Column Name: default.table4.x, Column Name: c, Key Sequence: 1)}] +PREHOOK: query: DESCRIBE FORMATTED table1 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table1 +POSTHOOK: query: DESCRIBE FORMATTED table1 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table1 +# col_name data_type comment + +a string +b string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: default.table1 +Constraint Name: #### A masked pattern was here #### +Column Names: a +PREHOOK: query: DESCRIBE FORMATTED table2 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table2 +POSTHOOK: query: DESCRIBE FORMATTED table2 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table2 +# col_name data_type comment + +a string +b string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: default.table2 +Constraint Name: pk1 +Column Names: a +PREHOOK: query: DESCRIBE FORMATTED table3 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table3 +POSTHOOK: query: DESCRIBE FORMATTED table3 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table3 +# col_name data_type comment + +x string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: default.table3 +Constraint Name: #### A masked pattern was here #### +Column Names: x +PREHOOK: query: DESCRIBE FORMATTED table4 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table4 +POSTHOOK: query: DESCRIBE FORMATTED table4 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table4 +# col_name data_type comment + +x string +y string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: default.table4 +Constraint Name: #### A masked pattern was here #### +Column Names: x + +# Foreign Keys +Table: default.table4 +Constraint Name: fk3 +Parent Column Name:default.table2.a Column Name:y Key Sequence:1 + +PREHOOK: query: DESCRIBE FORMATTED table5 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table5 +POSTHOOK: query: DESCRIBE FORMATTED table5 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table5 +# col_name data_type comment + +x string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: default.table5 +Constraint Name: #### A masked pattern was here #### +Column Names: x +PREHOOK: query: DESCRIBE FORMATTED table6 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table6 +POSTHOOK: query: DESCRIBE FORMATTED table6 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table6 +# col_name data_type comment + +x string +y string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: default.table6 +Constraint Name: #### A masked pattern was here #### +Column Names: x + +# Foreign Keys +Table: default.table6 +Constraint Name: fk4 +Parent Column Name:default.table1.a Column Name:y Key Sequence:1 + +PREHOOK: query: DESCRIBE FORMATTED table7 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table7 +POSTHOOK: query: DESCRIBE FORMATTED table7 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table7 +# col_name data_type comment + +a string +b string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: default.table7 +Constraint Name: #### A masked pattern was here #### +Column Names: a +PREHOOK: query: DESCRIBE FORMATTED table8 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table8 +POSTHOOK: query: DESCRIBE FORMATTED table8 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table8 +# col_name data_type comment + +a string +b string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: default.table8 +Constraint Name: pk8 +Column Names: a +PREHOOK: query: DESCRIBE FORMATTED table9 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table9 +POSTHOOK: query: DESCRIBE FORMATTED table9 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table9 +# col_name data_type comment + +a string +b string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: default.table9 +Constraint Name: #### A masked pattern was here #### +Column Names: a b +PREHOOK: query: DESCRIBE FORMATTED table10 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table10 +POSTHOOK: query: DESCRIBE FORMATTED table10 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table10 +# col_name data_type comment + +a string +b string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: default.table10 +Constraint Name: pk10 +Column Names: a + +# Foreign Keys +Table: default.table10 +Constraint Name: #### A masked pattern was here #### +Parent Column Name:default.table9.a Column Name:a Key Sequence:1 +Parent Column Name:default.table9.b Column Name:b Key Sequence:2 + +PREHOOK: query: DESCRIBE FORMATTED table11 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table11 +POSTHOOK: query: DESCRIBE FORMATTED table11 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table11 +# col_name data_type comment + +a string +b string +c string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: default.table11 +Constraint Name: pk11 +Column Names: a + +# Foreign Keys +Table: default.table11 +Constraint Name: #### A masked pattern was here #### +Parent Column Name:default.table9.a Column Name:a Key Sequence:1 +Parent Column Name:default.table9.b Column Name:b Key Sequence:2 + +Constraint Name: #### A masked pattern was here #### +Parent Column Name:default.table4.x Column Name:c Key Sequence:1 + PREHOOK: query: ALTER TABLE table2 DROP CONSTRAINT pk1 PREHOOK: type: ALTERTABLE_DROPCONSTRAINT POSTHOOK: query: ALTER TABLE table2 DROP CONSTRAINT pk1 @@ -104,6 +718,155 @@ PREHOOK: query: ALTER TABLE table6 DROP CONSTRAINT fk4 PREHOOK: type: ALTERTABLE_DROPCONSTRAINT POSTHOOK: query: ALTER TABLE table6 DROP CONSTRAINT fk4 POSTHOOK: type: ALTERTABLE_DROPCONSTRAINT +PREHOOK: query: DESCRIBE EXTENDED table2 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table2 +POSTHOOK: query: DESCRIBE EXTENDED table2 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table2 +a string +b string + +#### A masked pattern was here #### +PREHOOK: query: DESCRIBE EXTENDED table3 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table3 +POSTHOOK: query: DESCRIBE EXTENDED table3 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table3 +x string + +#### A masked pattern was here #### +Constraints Primary Key for default.table3:[x], Constraint Name: #### A masked pattern was here #### +PREHOOK: query: DESCRIBE EXTENDED table6 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table6 +POSTHOOK: query: DESCRIBE EXTENDED table6 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table6 +x string +y string + +#### A masked pattern was here #### +Constraints Primary Key for default.table6:[x], Constraint Name: #### A masked pattern was here #### +PREHOOK: query: DESCRIBE FORMATTED table2 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table2 +POSTHOOK: query: DESCRIBE FORMATTED table2 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table2 +# col_name data_type comment + +a string +b string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 +PREHOOK: query: DESCRIBE FORMATTED table3 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table3 +POSTHOOK: query: DESCRIBE FORMATTED table3 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table3 +# col_name data_type comment + +x string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: default.table3 +Constraint Name: #### A masked pattern was here #### +Column Names: x +PREHOOK: query: DESCRIBE FORMATTED table6 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@table6 +POSTHOOK: query: DESCRIBE FORMATTED table6 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@table6 +# col_name data_type comment + +x string +y string + +# Detailed Table Information +Database: default +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: default.table6 +Constraint Name: #### A masked pattern was here #### +Column Names: x PREHOOK: query: CREATE DATABASE dbconstraint PREHOOK: type: CREATEDATABASE PREHOOK: Output: database:dbconstraint @@ -130,7 +893,105 @@ PREHOOK: Input: database:default POSTHOOK: query: USE default POSTHOOK: type: SWITCHDATABASE POSTHOOK: Input: database:default +PREHOOK: query: DESCRIBE EXTENDED dbconstraint.table2 +PREHOOK: type: DESCTABLE +PREHOOK: Input: dbconstraint@table2 +POSTHOOK: query: DESCRIBE EXTENDED dbconstraint.table2 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: dbconstraint@table2 +a string +b string + +#### A masked pattern was here #### +Constraints Primary Key for dbconstraint.table2:[a], Constraint Name: pk1 +PREHOOK: query: DESCRIBE FORMATTED dbconstraint.table2 +PREHOOK: type: DESCTABLE +PREHOOK: Input: dbconstraint@table2 +POSTHOOK: query: DESCRIBE FORMATTED dbconstraint.table2 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: dbconstraint@table2 +# col_name data_type comment + +a string +b string + +# Detailed Table Information +Database: dbconstraint +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1 + +# Constraints + +# Primary Key +Table: dbconstraint.table2 +Constraint Name: pk1 +Column Names: a PREHOOK: query: ALTER TABLE dbconstraint.table2 DROP CONSTRAINT pk1 PREHOOK: type: ALTERTABLE_DROPCONSTRAINT POSTHOOK: query: ALTER TABLE dbconstraint.table2 DROP CONSTRAINT pk1 POSTHOOK: type: ALTERTABLE_DROPCONSTRAINT +PREHOOK: query: DESCRIBE EXTENDED dbconstraint.table2 +PREHOOK: type: DESCTABLE +PREHOOK: Input: dbconstraint@table2 +POSTHOOK: query: DESCRIBE EXTENDED dbconstraint.table2 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: dbconstraint@table2 +a string +b string + +#### A masked pattern was here #### +PREHOOK: query: DESCRIBE FORMATTED dbconstraint.table2 +PREHOOK: type: DESCTABLE +PREHOOK: Input: dbconstraint@table2 +POSTHOOK: query: DESCRIBE FORMATTED dbconstraint.table2 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: dbconstraint@table2 +# col_name data_type comment + +a string +b string + +# Detailed Table Information +Database: dbconstraint +#### A masked pattern was here #### +Retention: 0 +#### A masked pattern was here #### +Table Type: MANAGED_TABLE +Table Parameters: + COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + numFiles 0 + numRows 0 + rawDataSize 0 + totalSize 0 +#### A masked pattern was here #### + +# Storage Information +SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe +InputFormat: org.apache.hadoop.mapred.TextInputFormat +OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat +Compressed: No +Num Buckets: -1 +Bucket Columns: [] +Sort Columns: [] +Storage Desc Params: + serialization.format 1