Hi Are you using map-reduce as execution engine?
what version of Hive are you on? HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com On 22 June 2016 at 00:45, @Sanjiv Singh <sanjiv.is...@gmail.com> wrote: > Hi , > > I have big compressed data file *my_table.dat.gz* ( approx size 100 GB) > > # load staging table *STAGE_**my_table* from file *my_table.dat.gz* > > HIVE>> LOAD DATA INPATH '/var/lib/txt/*my_table.dat.gz*' OVERWRITE INTO > TABLE STAGE_my_table ; > > *# insert into ORC table "my_table"* > > HIVE>> INSERT INTO TABLE my_table SELECT * FROM TXT_my_table; > .... > INFO : Map 1: 0(+1)/1 Reducer 2: 0/1 > .... > > > Insertion into orc table in going on since 5-6 hours , Seems everything is > going sequential with one mapper reading complete file? > > Please suggest ? help me in improving ORC table load. > > > > > Regards > Sanjiv Singh > Mob : +091 9990-447-339 >