PREHOOK: query: -- Although the user has specified a bucketed map-join, the number of buckets in the table
-- do not match the number of files
drop table table1
PREHOOK: type: DROPTABLE
POSTHOOK: query: -- Although the user has specified a bucketed map-join, the number of buckets in the table
-- do not match the number of files
drop table table1
POSTHOOK: type: DROPTABLE
PREHOOK: query: drop table table2
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table table2
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table table1(key string, value string) clustered by (key, value)
into 2 BUCKETS stored as textfile
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table table1(key string, value string) clustered by (key, value)
into 2 BUCKETS stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@table1
PREHOOK: query: create table table2(key string, value string) clustered by (value, key)
into 2 BUCKETS stored as textfile
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table table2(key string, value string) clustered by (value, key)
into 2 BUCKETS stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@table2
PREHOOK: query: load data local inpath '../data/files/T1.txt' overwrite into table table1
PREHOOK: type: LOAD
PREHOOK: Output: default@table1
POSTHOOK: query: load data local inpath '../data/files/T1.txt' overwrite into table table1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@table1
PREHOOK: query: load data local inpath '../data/files/T1.txt' overwrite into table table2
PREHOOK: type: LOAD
PREHOOK: Output: default@table2
POSTHOOK: query: load data local inpath '../data/files/T1.txt' overwrite into table table2
POSTHOOK: type: LOAD
POSTHOOK: Output: default@table2
PREHOOK: query: load data local inpath '../data/files/T2.txt' overwrite into table table2
PREHOOK: type: LOAD
PREHOOK: Output: default@table2
POSTHOOK: query: load data local inpath '../data/files/T2.txt' overwrite into table table2
POSTHOOK: type: LOAD
POSTHOOK: Output: default@table2
FAILED: SemanticException [Error 10141]: Bucketed table metadata is not correct. Fix the metadata or don't use bucketed mapjoin, by setting hive.enforce.bucketmapjoin to false. The number of buckets for table table1 is 2, whereas the number of files is 1