Hi Rohan
I run your queries on the same version from trunk and did not get any
errors. Not sure why you are getting a semantic analysis error. It would be
good if you could send me a snapshot of the error message.
About the second issue of getting the same plan even if you
set hive.optimize.index
t;
> Also, could you give me an example of using indices to speed up joins?
>
> And for the semantic analysis thing, I sent the error in my first
> email, here are the lines that I modified to get it to work. Basically
> changed "_count_Of" to "_count_of"
>
> Reg
