Multi-INSERT Writing in Hive

October 12, 2021By Simo Hadoop

Multiple inserts:

with tmp_a as (

select name from tmp_test3

)

from tmp_a

insert overwrite table tmp_test1

select name where name = 'test123'

insert overwrite table tmp_test2

select name where name = 'test123'

with tmp_a as (

select name from tmp_test3

)

from tmp_a

insert overwrite table tmp_test1

select name where name = 'test123'

insert overwrite table tmp_test2

select name where name = 'test123'

hive, INSERT, Medium, multiple, write

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 4409 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment Cancel reply