Sign in
apache
/
hive
/
6b095edc31a9baa0ae805e2b5aea88101284d84b
/
.
/
ql
/
src
/
test
/
queries
/
clientpositive
/
column_name_is_table_alias.q
blob: 8821b5c0928c36929b2858a2cf0e1b160517dc85 [
file
] [
log
] [
blame
]
DROP TABLE IF EXISTS tableA
;
DROP TABLE IF EXISTS tableB
;
CREATE TABLE tableA
(
a INTEGER
,
z INTEGER
);
CREATE TABLE tableB
(
a INTEGER
,
b INTEGER
,
z INTEGER
);
SELECT a
.
z
,
b
.
b FROM tableB AS b JOIN tableA AS a ON a
.
a
=
b
.
b
;