Hello, Yes ofcourse, DDL for the first table: CREATE TABLE IF NOT EXISTS TableA(
a boolean,
b struct <
c: struct <
d: boolean,
e: string,
f: string,
g: struct <
h: string,
i: string,
j: string,
k: binary>,
l: string,
m: struct <
n: struct <
o: smallint,
p: smallint>,
r: struct <
s: tinyint,
t: smallint,
u: tinyint,
v: smallint>,
z`: struct <
aa: smallint,
bb: smallint>>,
cc: string>,
dd: boolean,
ee: string,
ff: string,
gg: array <struct <
name: string,
value: string>>,
hh: string,
ii: string,
jj: struct <
kk: string,
ll: string>,
mm: string>
)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
STORED AS TEXTFILE
TBLPROPERTIES ("immutable"="true") ; And the DDL for the second table: CREATE TABLE IF NOT EXISTS TableB (
a array <struct <
b: boolean,
c: string,
d: string,
e: array <string>,
f: string,
g: string,
h: string,
i: boolean,
j: string,
k: array <string>,
l: string,
m: string,
n: string,
o: string,
p: string,
q: string,
r: string,
s: boolean,
t: boolean,
y: boolean,
z: boolean,
w: string,
aa: string,
bb: int,
cc: string,
dd: boolean,
ee: string,
ff: string,
gg: string,
hh: boolean,
ii: boolean,
jj: boolean,
kk: boolean,
ll: string,
mm: string,
nn: boolean,
oo: boolean,
pp: array <int>,
qq: string,
tt: string,
rr: string,
zz: string,
aaa: string,
bbb: boolean,
ccc: int,
ddd: string,
eee: boolean,
fff: int>>
)
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
WITH SERDEPROPERTIES ( "ignore.malformed.json" = "true")
STORED AS TEXTFILE; I putted in bold and I underlined the fields on wich I'm doing the join. Note: I managed to find a workaround that is working in hue but is not woking in oozie) by doing the folowing: - altered the first table in order to add the kk column at the same level to the a column. - I changed the config: hive.auto.convert.join=false Thank you!
... View more
