Sign in
apache
/
hive
/
6b095edc31a9baa0ae805e2b5aea88101284d84b
/
.
/
ql
/
src
/
test
/
queries
/
clientpositive
/
udf_concat_insert2.q
blob: 98e3b7b31923ac13dcb722463ca49b0b73c2c97e [
file
] [
log
] [
blame
]
--!
qt
:
dataset
:
src
CREATE TABLE dest1_n108
(
key STRING
,
value STRING
)
STORED AS TEXTFILE
;
FROM src
INSERT OVERWRITE TABLE dest1_n108 SELECT concat
(
'1234'
,
'abc'
,
'extra argument'
),
src
.
value WHERE src
.
key
<
100
;
SELECT dest1_n108
.*
FROM dest1_n108
;