It seems to work only form command without parameters. If I define a variable by set hivevar:varname=value I cannot refer this variable. I.E !sh echo ${hivevar:varname} does not not return the string 'value' but the string '${hivevar:varaname}. Any idea to pass values to the command issued after the !sh?   ... View more

Hi to all   I'm looking for a solution to import and to partition dynamically data into ORC hive tables.   I've seent that with sqoop it is possibile di import and to partition data dynamically by the value of columns, but I've also seen that this feature is working only for the first run, because in the following job launchs I get an  'org.apache.hive.hcatalog.common.HCatException : 2002 : Partition already present with given partition key values' message since sqoop is aptempting toappend data to existing partitions.   Any idea to resolve this issue that make impossibile to use dynamic partioning in sqoop?   ... View more