how to write subquery and use “In” Clause in Hive

According to https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select:

“Hive does not support IN, EXISTS or subqueries in the WHERE clause.”

You might want to look at: https://issues.apache.org/jira/browse/HIVE-801

https://issues.apache.org/jira/browse/HIVE-1799

Related Posts:

  1. Why is Fetch task in Hive works faster than Map-only task?
  2. Hive: how to show all partitions of a table?
  3. fs.hdfs.impl.disable.cache caused SparkSQL very slow
  4. Hive dynamic partitioning
  5. Difference between hive.tez.container.size and tez.task.resource.memory.mb
  6. get “ERROR: Can’t get master address from ZooKeeper; znode data == null” when using Hbase shell
  7. Failed to locate the winutils binary in the hadoop binary path
  8. Name node is in safe mode. Not able to leave
  9. java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
  10. First hadoop project error: “Input path does not exist”
  11. Difference between `load data inpath ` and `location` in hive?
  12. What is Keyword Context in Hadoop programming world?
  13. Hadoop “Unable to load native-hadoop library for your platform” warning
  14. What is the difference between spark.sql.shuffle.partitions and spark.default.parallelism?
  15. How to Update/Drop a Hive Partition?
  16. connect to host localhost port 22: Connection refused
  17. What should be hadoop.tmp.dir ?
  18. Hive’s unix_timestamp and from_unixtime functions
  19. Difference between INNER JOIN and LEFT SEMI JOIN
  20. Hive Map-Join configuration mystery
  21. Where is the classpath set for hadoop

Leave a Comment

tech