Hi, I am trying to see how the following query works with indexes. Reading the logs, I am sure that the index is not used to execute the query. Applying HIVE-1644 <https://issues.apache.org/jira/browse/HIVE-1644>.19.patch also fails with the following errors. What should I do to make Hive use indexes?
Thank you in advance for your reply, Mahsa select * from pokes2 where name = 'Mark'; // name has been indexed root@rain:/usr/local/Hive9/hive-0.9.0# patch -p0 < \home\umroot\HIVE-1644.19.patch bash: homeumrootHIVE-1644.19.patch: No such file or directory root@rain:/usr/local/Hive9/hive-0.9.0# patch -p0 < \home\umroot\Downloads\HIVE-1644.19.patch bash: homeumrootDownloadsHIVE-1644.19.patch: No such file or directory root@rain:/usr/local/Hive9/hive-0.9.0# patch -p0 < /home/umroot/Downloads/HIVE-1644.19.patch patching file common/src/java/org/apache/hadoop/hive/conf/HiveConf.java Hunk #1 FAILED at 358. Hunk #2 FAILED at 366. 2 out of 2 hunks FAILED -- saving rejects to file common/src/java/org/apache/hadoop/hive/conf/HiveConf.java.rej patching file conf/hive-default.xml Hunk #1 FAILED at 325. Hunk #2 FAILED at 1011. 2 out of 2 hunks FAILED -- saving rejects to file conf/hive-default.xml.rej patching file eclipse-templates/.classpath Hunk #1 FAILED at 35. 1 out of 1 hunk FAILED -- saving rejects to file eclipse-templates/.classpath.rej patching file ql/src/java/org/apache/hadoop/hive/ql/Driver.java Hunk #1 FAILED at 317. Hunk #2 FAILED at 325. 2 out of 2 hunks FAILED -- saving rejects to file ql/src/java/org/apache/hadoop/hive/ql/Driver.java.rej patching file ql/src/java/org/apache/hadoop/hive/ql/exec/ExecDriver.java Hunk #1 FAILED at 277. Hunk #2 FAILED at 471. 2 out of 2 hunks FAILED -- saving rejects to file ql/src/java/org/apache/hadoop/hive/ql/exec/ExecDriver.java.rej patching file ql/src/java/org/apache/hadoop/hive/ql/exec/MapRedTask.java Hunk #1 FAILED at 126. 1 out of 1 hunk FAILED -- saving rejects to file ql/src/java/org/apache/hadoop/hive/ql/exec/MapRedTask.java.rej patching file ql/src/java/org/apache/hadoop/hive/ql/index/AbstractIndexHandler.java Hunk #1 FAILED at 20. Hunk #2 FAILED at 42. 2 out of 2 hunks FAILED -- saving rejects to file ql/src/java/org/apache/hadoop/hive/ql/index/AbstractIndexHandler.java.rej patching file ql/src/java/org/apache/hadoop/hive/ql/index/HiveIndexHandler.java Hunk #1 FAILED at 22. Hunk #2 FAILED at 114. 2 out of 2 hunks FAILED -- saving rejects to file ql/src/java/org/apache/hadoop/hive/ql/index/HiveIndexHandler.java.rej patching file ql/src/java/org/apache/hadoop/hive/ql/index/HiveIndexQueryContext.java patching file ql/src/java/org/apache/hadoop/hive/ql/index/compact/CompactIndexHandler.java Hunk #1 FAILED at 19. Hunk #2 FAILED at 33. Hunk #3 FAILED at 131. 3 out of 3 hunks FAILED -- saving rejects to file ql/src/java/org/apache/hadoop/hive/ql/index/compact/CompactIndexHandler.java.rej patching file ql/src/java/org/apache/hadoop/hive/ql/metadata/Table.java Hunk #1 FAILED at 38. Hunk #2 FAILED at 813. 2 out of 2 hunks FAILED -- saving rejects to file ql/src/java/org/apache/hadoop/hive/ql/metadata/Table.java.rej patching file ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/IndexWhereResolver.java patching file ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/PhysicalOptimizer.java Hunk #1 FAILED at 52. 1 out of 1 hunk FAILED -- saving rejects to file ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/PhysicalOptimizer.java.rej patching file ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/index/IndexWhereProcCtx.java patching file ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/index/IndexWhereProcessor.java patching file ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/index/IndexWhereTaskDispatcher.java patching file ql/src/java/org/apache/hadoop/hive/ql/parse/ParseContext.java Hunk #1 FAILED at 20. Hunk #2 FAILED at 33. Hunk #3 FAILED at 94. Hunk #4 FAILED at 129. Hunk #5 FAILED at 148. Hunk #6 FAILED at 173. Hunk #7 FAILED at 509. 7 out of 7 hunks FAILED -- saving rejects to file ql/src/java/org/apache/hadoop/hive/ql/parse/ParseContext.java.rej patching file ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java Hunk #1 FAILED at 315. Hunk #2 FAILED at 6856. 2 out of 2 hunks FAILED -- saving rejects to file ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java.rej patching file ql/src/java/org/apache/hadoop/hive/ql/plan/MapredWork.java Hunk #1 FAILED at 74. Hunk #2 FAILED at 380. 2 out of 2 hunks FAILED -- saving rejects to file ql/src/java/org/apache/hadoop/hive/ql/plan/MapredWork.java.rej patching file ql/src/test/queries/clientpositive/index_auto.q patching file ql/src/test/queries/clientpositive/index_auto_file_format.q patching file ql/src/test/queries/clientpositive/index_auto_multiple.q patching file ql/src/test/queries/clientpositive/index_auto_partitioned.q patching file ql/src/test/queries/clientpositive/index_auto_unused.q patching file ql/src/test/results/clientpositive/index_auto.q.out patching file ql/src/test/results/clientpositive/index_auto_file_format.q.out patching file ql/src/test/results/clientpositive/index_auto_multiple.q.out patching file ql/src/test/results/clientpositive/index_auto_partitioned.q.out patching file ql/src/test/results/clientpositive/index_auto_unused.q.out
