I believe that issue you are facing here is due to column type Geometry When data is present in HDFS , thought is mapped to a Hive Table, particular column must be in STRING  which is incompatible with Geometry type column in destination postgres,  Only option we have is to alter the column type to VARCHAR at postgres ... View more

Hi Ian, Thanks for taking time to have a look on it.   I actually tried to add backslash ( \' ) but did not worked. I also tried to add 2 quotes (/!\ not double quotes) same, it did not worked.   The only way it worked is to put the query behind double quotes : -q "my_query where col1 IN ('arg1','arg2')"   PS: As a reminder my script is on a Shell script file .sh   Thanks again Alex ... View more