This (NULL issue) can be caused by data schema mismatch. ... View more

Yes i didn't notice that it has space. So i used trim for it. ... View more

we are facing another ISSSUE: inserted only partial number of rows. The source table has 7,070,150,676. The insert query ran and we could see that from the source table same number of rows were transferred and beeline end screenshot also shows numRows = 7,070,150,676 but in the target hive table only 500,912,361 many rows were inserted.     The user is using QueryGrid.   Please hekp us to find the issue. ... View more

  the first thing you have to do in your script   set hive.variable.substitute=true; set current_date=${hiveconf:current_date};   command should be  hive  -v --hiveconf current_date='01-01-2015' -f argument.hql   it will execute successfully    -V willp rint the sql command in console appliocation      read hiveconf and hivevar  concepts      ... View more