@Jitendra Yadav: This is a bug https://issues.apache.org/jira/browse/HIVE-13120 for odbc only. It was checking for wrong user due to this bug. hive.fetch.task.conversion
Default Value: minimal in Hive 0.10.0 through 0.13.1, more in Hive 0.14.0 and later Added In: Hive 0.10.0 with HIVE-2925; default changed in Hive 0.14.0 with HIVE-7397 Some select queries can be converted to a single FETCH task, minimizing latency. Currently the query should be single sourced not having any subquery and should not have any aggregations or distincts (which incur RS – ReduceSinkOperator, requiring a MapReduce task), lateral views and joins. Supported values are none, minimal and more . 0. none : Disable hive.fetch.task.conversion (value added in Hive 0.14.0 with HIVE-8389)
1. minimal : SELECT *, FILTER on partition columns (WHERE and HAVING clauses), LIMIT only
2. more : SELECT, FILTER, LIMIT only (including TABLESAMPLE, virtual columns) " more " can take any kind of expressions in the SELECT clause, including UDFs.
(UDTFs and lateral views are not yet supported – see HIVE-5718.) So to resolve this issue we have to set none like below and in this way issue will get resolved. hive.fetch.task.conversion=none
... View more
