Hi Yash,

Thanks for your prompt response.

I was able to see that 404 is coming from QueryExecutionServiceImpl.getResultSet method. In that method ctx is null and the query handle isn't yet stored in finished_queries table hence the NotFoundException is raised. I can run other commands like show cubes etc. I don't think its a connection issue.

All the queries are running well from inmobi's hive cli.

I'm using Java 1.7 and maven 3.21. I was able to run Lens with the same tools earlier.

Regards,
-Pranav.

On 28/06/15 9:48 pm, Yash Sharma wrote:

Also mention ur env details and java/maven versions.
Would be helpful for us to debug.

Thanks

- Via mobile. Excuse brevity.

On 28 Jun 2015 9:46 pm, "Yash Sharma" <[email protected] <mailto:[email protected]>> wrote:

    Hi Pranav,
    The error does not highlight a lot of info about your error but i
    believe that a 404 might be a connection issue.

    Can u check if u can access hive directly (inmobi's version of
    hive). The root cause can be identified by the testcase u
    mentioned. I feel it might be related.

    Could you share more info or error logs. Lets figure out the root
    cause if it helps.

    Regards

    - Via mobile. Excuse brevity.

    On 28 Jun 2015 9:26 pm, "Pranav Kumar Agarwal" <[email protected]
    <mailto:[email protected]>> wrote:

        Hi Lens Gurus,

        I installed lens from latest and found that tests are failing:
        Running TestSuite
        Tests run: 31, *Failures: 21*, Errors: 0, Skipped: 0, Time
        elapsed: 41.213 sec <<< FAILURE! - in TestSuite
        testExecuteQuery(org.apache.lens.driver.hive.TestHiveDriver)
        Time elapsed: 1.068 sec  <<< FAILURE!

        I'm getting following error from CLI

        lens-shell>query execute select * from local_fact1
        28 Jun 2015 20:14:12,586 [Spring Shell] INFO cliLogger  -
        Query handle: 34eb78db-6f47-4079-841e-bf6f7a6e0b1e
        28 Jun 2015 20:14:17,854 [Spring Shell] INFO cliLogger  - User
        query: 'select * from local_fact1' was submitted to
        org.apache.lens.driver.hive.HiveDriver
28 Jun 2015 20:14:17,855 [Spring Shell] INFO cliLogger - Driver query: 'select * from local_fact1' and Driver handle:
        OperationHandle [opType=EXECUTE_STATEMENT,
        getHandleIdentifier()=8f489ef6-068f-4333-ba83-8333bea499f9]
        *Command failed java.lang.IllegalStateException: Failed to get
        resultset metadata, cause:HTTP 404 Not Found*
        lens-shell>query execute select * from local_fact1
        28 Jun 2015 20:14:25,233 [Spring Shell] INFO cliLogger  -
        Query handle: 1f59bc58-9272-4a95-8f95-cb3ad9225d69
        28 Jun 2015 20:14:26,211 [Spring Shell] INFO cliLogger  - User
        query: 'select * from local_fact1' was submitted to
        org.apache.lens.driver.hive.HiveDriver
28 Jun 2015 20:14:26,212 [Spring Shell] INFO cliLogger - Driver query: 'select * from local_fact1' and Driver handle:
        OperationHandle [opType=EXECUTE_STATEMENT,
        getHandleIdentifier()=4f1f8c9a-a9b3-4556-a2ba-b9ad3a8823b5]
        *0 rows process in (0) seconds.*

        There are 2 issues
        a) I intermittently get the result metadata failed with HTTP 404
        b) 0 rows returned.

        For each query fired via Lens I can see map reduce job getting
        initiated but the results for *all* queries is always 0 rows
        processed.

        Is this a known issue?

        Regards,
        -Pranav.


Reply via email to