Q: Is there some limitation of query length in RODBC sqlQuery() function? I wonder if there is query length limitation for sqlQuery function from RODBC package? I can't find any information in documentation but that's my hypothesis.
The thing is that when I use Hive editor to write a query I get correct output for my queries (including the long one). But when I connect through the sqlQuery() the long query (~250) doesn't work. I get error:
 [RODBC] ERROR: Could not SQLExecDirect 'my long query here'

I can't think about different reason why the query works in Hive editor and does not work with sqlQuery().  
I know 250 lines is a lot for SQL query but unfortunately I don't have permission to create temporary table in database I work with, so I do it in my code and that's why the code is so long. There's no way I can shorten the code.
Any help appreciated.
