Cannot run a query that uses intermediate tables to store data between the different SQL passes using the DataDirect Apache Hive Wire Protocol Driver. 
This query successfully executes while using the Hortonworks Hive Driver.

 

Steps to reproduce:

1] Open the ODBC Test Tool and connect to a Hive datasource.

2] Create tables LU_REGION, LU_MONTH,STATE_REGION and LU_QUARTER

3] Populate these tables with values

4] Execute the query :
select a12.QUARTER_ID  QUARTER_ID,
 max(a13.QUARTER_DESC)  QUARTER_DESC,
 a11.REGION_ID  REGION_ID,
 max(a14.REGION_NAME)  REGION_NAME,
 sum(a11.tot_dollar_sales)  WJXBFS1,
 rank() over ( partition by a12.QUARTER_ID order by sum(a11.tot_dollar_sales) asc, a11.REGION_ID asc )  WJXBFS2
from STATE_REGION_MNTH_SLS a11
 join LU_MONTH a12
   on  (a11.month_id = a12.month_id)
 join LU_QUARTER a13
   on  (a12.QUARTER_ID = a13.QUARTER_ID)
 join LU_REGION a14
   on  (a11.REGION_ID = a14.REGION_ID)
group by a12.QUARTER_ID,
 a11.REGION_ID

5] Observed Result : [DataDirect][ODBC Apache Hive Wire Protocol driver]General error.Protocol error.
Expected Result: The query should execute successfully and return results.
 

The exact cause is not known at this time.

To resolve the error and execute thr query successfully upgrade to 07.15.0350 (B0261, U0178) or later.