concatenation - hive concatenate partition all -
how concatenate partitions in 1 single command. eg , in case analyze stats , can run analyze table 'tablename' partition ( 'partition column name' ) compute statistics; dropping etc can run , alter table 'tablename' drop partition ( 'partition column name' '>/=/< etc' 'value' )
but seems there no way concatenate command whole partitions in 1 go.
for generating hdfs dfs -ls 'hdfs table location' | awk -f '/' '{print "alter table 'tablename' partition ("$nf") concatenate;"}'
is there way can same output in 1 command?
Comments
Post a Comment