[jira] [Created] (HIVE-20866) Result Caching doesnt work if order of the columns is changed in the query.
Nasrulla Khan Haris created HIVE-20866: -- Summary: Result Caching doesnt work if order of the columns is changed in the query. Key: HIVE-20866 URL: https://issues.apache.org/jira/browse/HIVE-20866 Project: Hive Issue Type: New Feature Reporter: Nasrulla Khan Haris # Run the query "select country,count💛 from hivesampletable group by country;" #  Make sure the result of the query is cached. #  Run the query by changing the order select count💛,country from hivesampletable group by country; #  Query in Step 3 should not spawn cluster tasks. cc: [~ashitg] -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (HIVE-20865) Query Result caching for queries which contain subqueries which are cached.
Nasrulla Khan Haris created HIVE-20865: -- Summary: Query Result caching for queries which contain subqueries which are cached. Key: HIVE-20865 URL: https://issues.apache.org/jira/browse/HIVE-20865 Project: Hive Issue Type: New Feature Components: Hive Reporter: Nasrulla Khan Haris Steps: 1. Execute query select count💛 from hivesampletable where country='United States' 2. Make sure the query results for the query in step 1 is cached. 3. Execute select count💛 from hivesampletable where country='United States' or Country="United Kingdom"; 4. Query should not spawn cluster tasks to execute select count💛 from hivesampletable where country='United States'  cc : [~ashitg] -- This message was sent by Atlassian JIRA (v7.6.3#76005)