Hi, I am working on Hive 0.14 version. Where i am able to delete and update the records.
But while insert with selected columns like, Insert into table table1(col1,col2) select col1,col2 from table2 where table1.id = table2.id These type of query, i am getting error. As per the jira help, i am trying execute the patch as HIVE-9481.4.patch and HIVE-9481.2.patch but i am facing issues are, [cloudera@quickstart sri]$ patch -p0 < HIVE-9481.2.patch (Stripping trailing CRs from patch.) can't find file to patch at input line 5 Perhaps you used the wrong -p or --strip option? The text leading up to this was: -------------------------- |diff --git ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g |index 9c7603c..b4c0ba6 100644 |--- ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g |+++ ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g -------------------------- File to patch: HIVE-9481.2.patch patching file HIVE-9481.2.patch Hunk #1 FAILED at 2216. 1 out of 1 hunk FAILED -- saving rejects to file HIVE-9481.2.patch.rej (Stripping trailing CRs from patch.) can't find file to patch at input line 20 Perhaps you used the wrong -p or --strip option? The text leading up to this was: -------------------------- |diff --git ql/src/java/org/apache/hadoop/hive/ql/parse/QBMetaData.java ql/src/java/org/apache/hadoop/hive/ql/parse/QBMetaData.java |index e8f3284..33c2f18 100644 |--- ql/src/java/org/apache/hadoop/hive/ql/parse/QBMetaData.java |+++ ql/src/java/org/apache/hadoop/hive/ql/parse/QBMetaData.java Please help me in step by step in apply patch in hive to solve the above issue Thanks in advance *Thanks & Regards,* *Srinivas T*