You need to use CONCAT_WS (separator,col1,col2,...colX) : select CONCAT_WS ('',c12,c13,c14,c15,c16) FROM your_table; , Use CONCAT_WS , where you give the separator as 1st term and then the list of columns to concat : select CONCAT_WS (' ',c12,c13,c14,c15,c16) from your_table) ; ... View more

@tomoya yoshida It seems you have increased hive.tez.container.size but yarn.scheduler.maximum-allocation-mb is still set to 2250 MB. Can you try increasing yarn.scheduler.maximum-allocation-mb to more than 3750 MB. you need to accordingly set the value of this yarn.nodemanager.resource.memory-mb property. Let me know if it doesn't work after changing this. ... View more

You can also run DESC <TABLE_NAME> command from CLI or BEELINE. ... View more