You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by Rajat Khandelwal <ra...@gmail.com> on 2016/01/14 09:06:08 UTC
Review Request 42291: LENS-923: CLI should allow query execution
without the prefix "query execute"
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/42291/
-----------------------------------------------------------
Review request for lens.
Bugs: LENS-923
https://issues.apache.org/jira/browse/LENS-923
Repository: lens
Description
-------
Diffs
-----
lens-cli/src/main/java/org/apache/lens/cli/commands/BaseLensCommand.java 643772596c4724253333c0688a93ed621b4dba45
lens-cli/src/main/java/org/apache/lens/cli/commands/LensLogResourceCommands.java 59b7355e832eac66b7054bcb33a3ec7e6dfb78ba
lens-cli/src/main/java/org/apache/lens/cli/commands/LensQueryCommands.java a29600d25d89e73f26102ba609e04b73f4cb7c58
src/site/apt/user/cli.apt 65380e680f1370820cf361457ad5286e6e95fd39
Diff: https://reviews.apache.org/r/42291/diff/
Testing
-------
Thanks,
Rajat Khandelwal
Re: Review Request 42291: LENS-923: CLI should allow query execution
without the prefix "query execute"
Posted by Rajat Khandelwal <ra...@gmail.com>.
> On Jan. 20, 2016, 8:30 p.m., Raju Bairishetti wrote:
> > lens-cli/src/main/java/org/apache/lens/cli/commands/BaseLensCommand.java, line 197
> > <https://reviews.apache.org/r/42291/diff/3/?file=1199724#file1199724line197>
> >
> > Can you make it **protected**?
Test cases are using this and the test case is not in the same package. So I can't make it protected without moving the test cases.
> On Jan. 20, 2016, 8:30 p.m., Raju Bairishetti wrote:
> > lens-cli/src/main/java/org/apache/lens/cli/commands/LensLogResourceCommands.java, line 52
> > <https://reviews.apache.org/r/42291/diff/3/?file=1199725#file1199725line52>
> >
> > This command is not only used for fetching query logs. It can be used for fetching other logs like server logs or logs under logs.dir system property etc....
> >
> > IMO, we should not simply assume user is querying for query logs when this option is absent.
I agree that the command has a wider usage. But this modification allows for a smoother workflow for the user.
One such flow is: http://showterm.io/6b11abcfe6fccc7391fd5
Use case:
1. Run a sync query with in memory resultset
2. Query finishes
3. I want the logs of the query
Before LENS-836, user had to do the following:
1. query execute `query`
2. query finishes and prints result
2. query list --state SUCCESSFUL
3. find query id by hit and trial
4. show logs `query id`
After LENS-836, but before LENS-923, user can do this:
1. query execute `query`
2. query details
3. details will have id
3. show logs `query_id`
After LENS-923, the flow will be:
1. `query`
2. show logs
So In the interest of enhanced user experience, I propose let's have default values for the `show logs` command too.
- Rajat
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/42291/#review115430
-----------------------------------------------------------
On Jan. 18, 2016, 11:39 a.m., Rajat Khandelwal wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/42291/
> -----------------------------------------------------------
>
> (Updated Jan. 18, 2016, 11:39 a.m.)
>
>
> Review request for lens.
>
>
> Bugs: LENS-923
> https://issues.apache.org/jira/browse/LENS-923
>
>
> Repository: lens
>
>
> Description
> -------
>
>
> Diffs
> -----
>
> lens-cli/src/main/java/org/apache/lens/cli/commands/BaseLensCommand.java 643772596c4724253333c0688a93ed621b4dba45
> lens-cli/src/main/java/org/apache/lens/cli/commands/LensLogResourceCommands.java 59b7355e832eac66b7054bcb33a3ec7e6dfb78ba
> lens-cli/src/main/java/org/apache/lens/cli/commands/LensQueryCommands.java a29600d25d89e73f26102ba609e04b73f4cb7c58
> src/site/apt/user/cli.apt 65380e680f1370820cf361457ad5286e6e95fd39
>
> Diff: https://reviews.apache.org/r/42291/diff/
>
>
> Testing
> -------
>
> ```
> $ bin/lens-cli.sh
> =======================================
> * *
> * Lens Client *
> * *
> =======================================
>
> Welcome to Lens Client
> lens-shell>select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2
> 14 Jan 2016 07:44:41 [Spring Shell] INFO cliLogger - Query handle: f255a717-2dfb-42fe-9a80-8308efae054c
> 14 Jan 2016 07:44:46 [Spring Shell] INFO cliLogger - User query: 'select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2' was submitted to hive/hive1
> 14 Jan 2016 07:44:46 [Spring Shell] INFO cliLogger - Driver query: 'INSERT OVERWRITE DIRECTORY "file:/tmp/lensreports/hdfsout/f255a717-2dfb-42fe-9a80-8308efae054c" SELECT ( sample_dim_chain . name ), sum(( sample_cube . measure2 )) FROM local_fact2 sample_cube join local_dim_table sample_dim_chain on sample_cube.dim3 = sample_dim_chain.id and (sample_dim_chain.dt = 'latest') WHERE ((((( sample_cube . dt ) = '2014-06-25' ) and (( sample_dim_chain . name ) != "first" )))) GROUP BY ( sample_dim_chain . name ) ORDER BY sample_dim_chain . name desc LIMIT 2 ' and Driver handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=75a2615a-8cac-45b3-b070-e284d415a8b4]
> 14 Jan 2016 07:44:56 [Spring Shell] INFO cliLogger - Query Status: Status : RUNNING
> Message : Query is running in HiveServer!
> Progress : 0.5
> Progress Message : [{"taskId":"Stage-6","type":"MAPREDLOCAL","externalHandle":"Stage-6","taskState":"FINISHED_STATE"},{"taskId":"Stage-2","type":"MAPRED","externalHandle":null,"taskState":"FINISHED_STATE"},{"taskId":"Stage-3","type":"MAPRED","externalHandle":null,"taskState":"RUNNING_STATE"},{"taskId":"Stage-0","type":"MOVE","externalHandle":"Stage-0","taskState":"UNKNOWN_STATE"}]
>
> 14 Jan 2016 07:44:58 [Spring Shell] INFO cliLogger - Query Status: Status : SUCCESSFUL
> Message : Query is successful!
> Progress : 1.0
> Result Available
> sample_dim_chain.name _c1
> Results of query stored at : file:/tmp/lensreports/hdfsout/f255a717-2dfb-42fe-9a80-8308efae054c processed in (17) seconds.
>
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2
> 14 Jan 2016 07:44:58 [Spring Shell] INFO cliLogger - Query handle: 894c458c-1555-4690-b2b0-ca3fc10b2eb8
> 14 Jan 2016 07:45:04 [Spring Shell] INFO cliLogger - User query: 'cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2' was submitted to hive/hive1
> 14 Jan 2016 07:45:04 [Spring Shell] INFO cliLogger - Driver query: 'INSERT OVERWRITE DIRECTORY "file:/tmp/lensreports/hdfsout/894c458c-1555-4690-b2b0-ca3fc10b2eb8" SELECT ( sample_dim_chain . name ), sum(( sample_cube . measure2 )) FROM local_fact2 sample_cube join local_dim_table sample_dim_chain on sample_cube.dim3 = sample_dim_chain.id and (sample_dim_chain.dt = 'latest') WHERE ((((( sample_cube . dt ) = '2014-06-25' ) and (( sample_dim_chain . name ) != "first" )))) GROUP BY ( sample_dim_chain . name ) ORDER BY sample_dim_chain . name desc LIMIT 2 ' and Driver handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=cfe47ca3-32fe-44c8-999a-138943150dee]
> 14 Jan 2016 07:45:14 [Spring Shell] INFO cliLogger - Query Status: Status : RUNNING
> Message : Query is running in HiveServer!
> Progress : 0.5
> Progress Message : [{"taskId":"Stage-6","type":"MAPREDLOCAL","externalHandle":"Stage-6","taskState":"FINISHED_STATE"},{"taskId":"Stage-2","type":"MAPRED","externalHandle":null,"taskState":"FINISHED_STATE"},{"taskId":"Stage-3","type":"MAPRED","externalHandle":null,"taskState":"RUNNING_STATE"},{"taskId":"Stage-0","type":"MOVE","externalHandle":"Stage-0","taskState":"UNKNOWN_STATE"}]
>
> 14 Jan 2016 07:45:14 [Spring Shell] INFO cliLogger - Query Status: Status : SUCCESSFUL
> Message : Query is successful!
> Progress : 1.0
> Result Available
> sample_dim_chain.name _c1
> Results of query stored at : file:/tmp/lensreports/hdfsout/894c458c-1555-4690-b2b0-ca3fc10b2eb8 processed in (15) seconds.
>
> lens-shell>select --query
>
> required --query: <query-string>; no default value
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async
> 918534fb-3eff-42da-a1dd-25f43a78d377
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async -0n
>
> optional --async: <async>; default if option present: 'true'; default if option not present: 'false'
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async --name
>
> optional --name: <query-name>; no default value
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async --name myquery
> 7009e162-f448-40a6-b297-004499eb8b83
> lens-shell>
> ```
>
>
> Thanks,
>
> Rajat Khandelwal
>
>
Re: Review Request 42291: LENS-923: CLI should allow query execution
without the prefix "query execute"
Posted by Raju Bairishetti <ra...@gmail.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/42291/#review115430
-----------------------------------------------------------
lens-cli/src/main/java/org/apache/lens/cli/commands/BaseLensCommand.java (line 197)
<https://reviews.apache.org/r/42291/#comment176424>
Can you make it **protected**?
lens-cli/src/main/java/org/apache/lens/cli/commands/LensLogResourceCommands.java (line 52)
<https://reviews.apache.org/r/42291/#comment176426>
This command is not only used for fetching query logs. It can be used for fetching other logs like server logs or logs under logs.dir system property etc....
IMO, we should not simply assume user is querying for query logs when this option is absent.
- Raju Bairishetti
On Jan. 18, 2016, 6:09 a.m., Rajat Khandelwal wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/42291/
> -----------------------------------------------------------
>
> (Updated Jan. 18, 2016, 6:09 a.m.)
>
>
> Review request for lens.
>
>
> Bugs: LENS-923
> https://issues.apache.org/jira/browse/LENS-923
>
>
> Repository: lens
>
>
> Description
> -------
>
>
> Diffs
> -----
>
> lens-cli/src/main/java/org/apache/lens/cli/commands/BaseLensCommand.java 643772596c4724253333c0688a93ed621b4dba45
> lens-cli/src/main/java/org/apache/lens/cli/commands/LensLogResourceCommands.java 59b7355e832eac66b7054bcb33a3ec7e6dfb78ba
> lens-cli/src/main/java/org/apache/lens/cli/commands/LensQueryCommands.java a29600d25d89e73f26102ba609e04b73f4cb7c58
> src/site/apt/user/cli.apt 65380e680f1370820cf361457ad5286e6e95fd39
>
> Diff: https://reviews.apache.org/r/42291/diff/
>
>
> Testing
> -------
>
> ```
> $ bin/lens-cli.sh
> =======================================
> * *
> * Lens Client *
> * *
> =======================================
>
> Welcome to Lens Client
> lens-shell>select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2
> 14 Jan 2016 07:44:41 [Spring Shell] INFO cliLogger - Query handle: f255a717-2dfb-42fe-9a80-8308efae054c
> 14 Jan 2016 07:44:46 [Spring Shell] INFO cliLogger - User query: 'select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2' was submitted to hive/hive1
> 14 Jan 2016 07:44:46 [Spring Shell] INFO cliLogger - Driver query: 'INSERT OVERWRITE DIRECTORY "file:/tmp/lensreports/hdfsout/f255a717-2dfb-42fe-9a80-8308efae054c" SELECT ( sample_dim_chain . name ), sum(( sample_cube . measure2 )) FROM local_fact2 sample_cube join local_dim_table sample_dim_chain on sample_cube.dim3 = sample_dim_chain.id and (sample_dim_chain.dt = 'latest') WHERE ((((( sample_cube . dt ) = '2014-06-25' ) and (( sample_dim_chain . name ) != "first" )))) GROUP BY ( sample_dim_chain . name ) ORDER BY sample_dim_chain . name desc LIMIT 2 ' and Driver handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=75a2615a-8cac-45b3-b070-e284d415a8b4]
> 14 Jan 2016 07:44:56 [Spring Shell] INFO cliLogger - Query Status: Status : RUNNING
> Message : Query is running in HiveServer!
> Progress : 0.5
> Progress Message : [{"taskId":"Stage-6","type":"MAPREDLOCAL","externalHandle":"Stage-6","taskState":"FINISHED_STATE"},{"taskId":"Stage-2","type":"MAPRED","externalHandle":null,"taskState":"FINISHED_STATE"},{"taskId":"Stage-3","type":"MAPRED","externalHandle":null,"taskState":"RUNNING_STATE"},{"taskId":"Stage-0","type":"MOVE","externalHandle":"Stage-0","taskState":"UNKNOWN_STATE"}]
>
> 14 Jan 2016 07:44:58 [Spring Shell] INFO cliLogger - Query Status: Status : SUCCESSFUL
> Message : Query is successful!
> Progress : 1.0
> Result Available
> sample_dim_chain.name _c1
> Results of query stored at : file:/tmp/lensreports/hdfsout/f255a717-2dfb-42fe-9a80-8308efae054c processed in (17) seconds.
>
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2
> 14 Jan 2016 07:44:58 [Spring Shell] INFO cliLogger - Query handle: 894c458c-1555-4690-b2b0-ca3fc10b2eb8
> 14 Jan 2016 07:45:04 [Spring Shell] INFO cliLogger - User query: 'cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2' was submitted to hive/hive1
> 14 Jan 2016 07:45:04 [Spring Shell] INFO cliLogger - Driver query: 'INSERT OVERWRITE DIRECTORY "file:/tmp/lensreports/hdfsout/894c458c-1555-4690-b2b0-ca3fc10b2eb8" SELECT ( sample_dim_chain . name ), sum(( sample_cube . measure2 )) FROM local_fact2 sample_cube join local_dim_table sample_dim_chain on sample_cube.dim3 = sample_dim_chain.id and (sample_dim_chain.dt = 'latest') WHERE ((((( sample_cube . dt ) = '2014-06-25' ) and (( sample_dim_chain . name ) != "first" )))) GROUP BY ( sample_dim_chain . name ) ORDER BY sample_dim_chain . name desc LIMIT 2 ' and Driver handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=cfe47ca3-32fe-44c8-999a-138943150dee]
> 14 Jan 2016 07:45:14 [Spring Shell] INFO cliLogger - Query Status: Status : RUNNING
> Message : Query is running in HiveServer!
> Progress : 0.5
> Progress Message : [{"taskId":"Stage-6","type":"MAPREDLOCAL","externalHandle":"Stage-6","taskState":"FINISHED_STATE"},{"taskId":"Stage-2","type":"MAPRED","externalHandle":null,"taskState":"FINISHED_STATE"},{"taskId":"Stage-3","type":"MAPRED","externalHandle":null,"taskState":"RUNNING_STATE"},{"taskId":"Stage-0","type":"MOVE","externalHandle":"Stage-0","taskState":"UNKNOWN_STATE"}]
>
> 14 Jan 2016 07:45:14 [Spring Shell] INFO cliLogger - Query Status: Status : SUCCESSFUL
> Message : Query is successful!
> Progress : 1.0
> Result Available
> sample_dim_chain.name _c1
> Results of query stored at : file:/tmp/lensreports/hdfsout/894c458c-1555-4690-b2b0-ca3fc10b2eb8 processed in (15) seconds.
>
> lens-shell>select --query
>
> required --query: <query-string>; no default value
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async
> 918534fb-3eff-42da-a1dd-25f43a78d377
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async -0n
>
> optional --async: <async>; default if option present: 'true'; default if option not present: 'false'
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async --name
>
> optional --name: <query-name>; no default value
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async --name myquery
> 7009e162-f448-40a6-b297-004499eb8b83
> lens-shell>
> ```
>
>
> Thanks,
>
> Rajat Khandelwal
>
>
Re: Review Request 42291: LENS-923: CLI should allow query execution
without the prefix "query execute"
Posted by Amareshwari Sriramadasu <am...@apache.org>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/42291/#review115113
-----------------------------------------------------------
Ship it!
Ship It!
- Amareshwari Sriramadasu
On Jan. 18, 2016, 6:09 a.m., Rajat Khandelwal wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/42291/
> -----------------------------------------------------------
>
> (Updated Jan. 18, 2016, 6:09 a.m.)
>
>
> Review request for lens.
>
>
> Bugs: LENS-923
> https://issues.apache.org/jira/browse/LENS-923
>
>
> Repository: lens
>
>
> Description
> -------
>
>
> Diffs
> -----
>
> lens-cli/src/main/java/org/apache/lens/cli/commands/BaseLensCommand.java 643772596c4724253333c0688a93ed621b4dba45
> lens-cli/src/main/java/org/apache/lens/cli/commands/LensLogResourceCommands.java 59b7355e832eac66b7054bcb33a3ec7e6dfb78ba
> lens-cli/src/main/java/org/apache/lens/cli/commands/LensQueryCommands.java a29600d25d89e73f26102ba609e04b73f4cb7c58
> src/site/apt/user/cli.apt 65380e680f1370820cf361457ad5286e6e95fd39
>
> Diff: https://reviews.apache.org/r/42291/diff/
>
>
> Testing
> -------
>
> ```
> $ bin/lens-cli.sh
> =======================================
> * *
> * Lens Client *
> * *
> =======================================
>
> Welcome to Lens Client
> lens-shell>select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2
> 14 Jan 2016 07:44:41 [Spring Shell] INFO cliLogger - Query handle: f255a717-2dfb-42fe-9a80-8308efae054c
> 14 Jan 2016 07:44:46 [Spring Shell] INFO cliLogger - User query: 'select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2' was submitted to hive/hive1
> 14 Jan 2016 07:44:46 [Spring Shell] INFO cliLogger - Driver query: 'INSERT OVERWRITE DIRECTORY "file:/tmp/lensreports/hdfsout/f255a717-2dfb-42fe-9a80-8308efae054c" SELECT ( sample_dim_chain . name ), sum(( sample_cube . measure2 )) FROM local_fact2 sample_cube join local_dim_table sample_dim_chain on sample_cube.dim3 = sample_dim_chain.id and (sample_dim_chain.dt = 'latest') WHERE ((((( sample_cube . dt ) = '2014-06-25' ) and (( sample_dim_chain . name ) != "first" )))) GROUP BY ( sample_dim_chain . name ) ORDER BY sample_dim_chain . name desc LIMIT 2 ' and Driver handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=75a2615a-8cac-45b3-b070-e284d415a8b4]
> 14 Jan 2016 07:44:56 [Spring Shell] INFO cliLogger - Query Status: Status : RUNNING
> Message : Query is running in HiveServer!
> Progress : 0.5
> Progress Message : [{"taskId":"Stage-6","type":"MAPREDLOCAL","externalHandle":"Stage-6","taskState":"FINISHED_STATE"},{"taskId":"Stage-2","type":"MAPRED","externalHandle":null,"taskState":"FINISHED_STATE"},{"taskId":"Stage-3","type":"MAPRED","externalHandle":null,"taskState":"RUNNING_STATE"},{"taskId":"Stage-0","type":"MOVE","externalHandle":"Stage-0","taskState":"UNKNOWN_STATE"}]
>
> 14 Jan 2016 07:44:58 [Spring Shell] INFO cliLogger - Query Status: Status : SUCCESSFUL
> Message : Query is successful!
> Progress : 1.0
> Result Available
> sample_dim_chain.name _c1
> Results of query stored at : file:/tmp/lensreports/hdfsout/f255a717-2dfb-42fe-9a80-8308efae054c processed in (17) seconds.
>
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2
> 14 Jan 2016 07:44:58 [Spring Shell] INFO cliLogger - Query handle: 894c458c-1555-4690-b2b0-ca3fc10b2eb8
> 14 Jan 2016 07:45:04 [Spring Shell] INFO cliLogger - User query: 'cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2' was submitted to hive/hive1
> 14 Jan 2016 07:45:04 [Spring Shell] INFO cliLogger - Driver query: 'INSERT OVERWRITE DIRECTORY "file:/tmp/lensreports/hdfsout/894c458c-1555-4690-b2b0-ca3fc10b2eb8" SELECT ( sample_dim_chain . name ), sum(( sample_cube . measure2 )) FROM local_fact2 sample_cube join local_dim_table sample_dim_chain on sample_cube.dim3 = sample_dim_chain.id and (sample_dim_chain.dt = 'latest') WHERE ((((( sample_cube . dt ) = '2014-06-25' ) and (( sample_dim_chain . name ) != "first" )))) GROUP BY ( sample_dim_chain . name ) ORDER BY sample_dim_chain . name desc LIMIT 2 ' and Driver handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=cfe47ca3-32fe-44c8-999a-138943150dee]
> 14 Jan 2016 07:45:14 [Spring Shell] INFO cliLogger - Query Status: Status : RUNNING
> Message : Query is running in HiveServer!
> Progress : 0.5
> Progress Message : [{"taskId":"Stage-6","type":"MAPREDLOCAL","externalHandle":"Stage-6","taskState":"FINISHED_STATE"},{"taskId":"Stage-2","type":"MAPRED","externalHandle":null,"taskState":"FINISHED_STATE"},{"taskId":"Stage-3","type":"MAPRED","externalHandle":null,"taskState":"RUNNING_STATE"},{"taskId":"Stage-0","type":"MOVE","externalHandle":"Stage-0","taskState":"UNKNOWN_STATE"}]
>
> 14 Jan 2016 07:45:14 [Spring Shell] INFO cliLogger - Query Status: Status : SUCCESSFUL
> Message : Query is successful!
> Progress : 1.0
> Result Available
> sample_dim_chain.name _c1
> Results of query stored at : file:/tmp/lensreports/hdfsout/894c458c-1555-4690-b2b0-ca3fc10b2eb8 processed in (15) seconds.
>
> lens-shell>select --query
>
> required --query: <query-string>; no default value
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async
> 918534fb-3eff-42da-a1dd-25f43a78d377
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async -0n
>
> optional --async: <async>; default if option present: 'true'; default if option not present: 'false'
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async --name
>
> optional --name: <query-name>; no default value
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async --name myquery
> 7009e162-f448-40a6-b297-004499eb8b83
> lens-shell>
> ```
>
>
> Thanks,
>
> Rajat Khandelwal
>
>
Re: Review Request 42291: LENS-923: CLI should allow query execution
without the prefix "query execute"
Posted by Rajat Khandelwal <ra...@gmail.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/42291/
-----------------------------------------------------------
(Updated Jan. 18, 2016, 11:39 a.m.)
Review request for lens.
Bugs: LENS-923
https://issues.apache.org/jira/browse/LENS-923
Repository: lens
Description
-------
Diffs (updated)
-----
lens-cli/src/main/java/org/apache/lens/cli/commands/BaseLensCommand.java 643772596c4724253333c0688a93ed621b4dba45
lens-cli/src/main/java/org/apache/lens/cli/commands/LensLogResourceCommands.java 59b7355e832eac66b7054bcb33a3ec7e6dfb78ba
lens-cli/src/main/java/org/apache/lens/cli/commands/LensQueryCommands.java a29600d25d89e73f26102ba609e04b73f4cb7c58
src/site/apt/user/cli.apt 65380e680f1370820cf361457ad5286e6e95fd39
Diff: https://reviews.apache.org/r/42291/diff/
Testing
-------
```
$ bin/lens-cli.sh
=======================================
* *
* Lens Client *
* *
=======================================
Welcome to Lens Client
lens-shell>select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2
14 Jan 2016 07:44:41 [Spring Shell] INFO cliLogger - Query handle: f255a717-2dfb-42fe-9a80-8308efae054c
14 Jan 2016 07:44:46 [Spring Shell] INFO cliLogger - User query: 'select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2' was submitted to hive/hive1
14 Jan 2016 07:44:46 [Spring Shell] INFO cliLogger - Driver query: 'INSERT OVERWRITE DIRECTORY "file:/tmp/lensreports/hdfsout/f255a717-2dfb-42fe-9a80-8308efae054c" SELECT ( sample_dim_chain . name ), sum(( sample_cube . measure2 )) FROM local_fact2 sample_cube join local_dim_table sample_dim_chain on sample_cube.dim3 = sample_dim_chain.id and (sample_dim_chain.dt = 'latest') WHERE ((((( sample_cube . dt ) = '2014-06-25' ) and (( sample_dim_chain . name ) != "first" )))) GROUP BY ( sample_dim_chain . name ) ORDER BY sample_dim_chain . name desc LIMIT 2 ' and Driver handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=75a2615a-8cac-45b3-b070-e284d415a8b4]
14 Jan 2016 07:44:56 [Spring Shell] INFO cliLogger - Query Status: Status : RUNNING
Message : Query is running in HiveServer!
Progress : 0.5
Progress Message : [{"taskId":"Stage-6","type":"MAPREDLOCAL","externalHandle":"Stage-6","taskState":"FINISHED_STATE"},{"taskId":"Stage-2","type":"MAPRED","externalHandle":null,"taskState":"FINISHED_STATE"},{"taskId":"Stage-3","type":"MAPRED","externalHandle":null,"taskState":"RUNNING_STATE"},{"taskId":"Stage-0","type":"MOVE","externalHandle":"Stage-0","taskState":"UNKNOWN_STATE"}]
14 Jan 2016 07:44:58 [Spring Shell] INFO cliLogger - Query Status: Status : SUCCESSFUL
Message : Query is successful!
Progress : 1.0
Result Available
sample_dim_chain.name _c1
Results of query stored at : file:/tmp/lensreports/hdfsout/f255a717-2dfb-42fe-9a80-8308efae054c processed in (17) seconds.
lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2
14 Jan 2016 07:44:58 [Spring Shell] INFO cliLogger - Query handle: 894c458c-1555-4690-b2b0-ca3fc10b2eb8
14 Jan 2016 07:45:04 [Spring Shell] INFO cliLogger - User query: 'cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2' was submitted to hive/hive1
14 Jan 2016 07:45:04 [Spring Shell] INFO cliLogger - Driver query: 'INSERT OVERWRITE DIRECTORY "file:/tmp/lensreports/hdfsout/894c458c-1555-4690-b2b0-ca3fc10b2eb8" SELECT ( sample_dim_chain . name ), sum(( sample_cube . measure2 )) FROM local_fact2 sample_cube join local_dim_table sample_dim_chain on sample_cube.dim3 = sample_dim_chain.id and (sample_dim_chain.dt = 'latest') WHERE ((((( sample_cube . dt ) = '2014-06-25' ) and (( sample_dim_chain . name ) != "first" )))) GROUP BY ( sample_dim_chain . name ) ORDER BY sample_dim_chain . name desc LIMIT 2 ' and Driver handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=cfe47ca3-32fe-44c8-999a-138943150dee]
14 Jan 2016 07:45:14 [Spring Shell] INFO cliLogger - Query Status: Status : RUNNING
Message : Query is running in HiveServer!
Progress : 0.5
Progress Message : [{"taskId":"Stage-6","type":"MAPREDLOCAL","externalHandle":"Stage-6","taskState":"FINISHED_STATE"},{"taskId":"Stage-2","type":"MAPRED","externalHandle":null,"taskState":"FINISHED_STATE"},{"taskId":"Stage-3","type":"MAPRED","externalHandle":null,"taskState":"RUNNING_STATE"},{"taskId":"Stage-0","type":"MOVE","externalHandle":"Stage-0","taskState":"UNKNOWN_STATE"}]
14 Jan 2016 07:45:14 [Spring Shell] INFO cliLogger - Query Status: Status : SUCCESSFUL
Message : Query is successful!
Progress : 1.0
Result Available
sample_dim_chain.name _c1
Results of query stored at : file:/tmp/lensreports/hdfsout/894c458c-1555-4690-b2b0-ca3fc10b2eb8 processed in (15) seconds.
lens-shell>select --query
required --query: <query-string>; no default value
lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async
918534fb-3eff-42da-a1dd-25f43a78d377
lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async -0n
optional --async: <async>; default if option present: 'true'; default if option not present: 'false'
lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async --name
optional --name: <query-name>; no default value
lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async --name myquery
7009e162-f448-40a6-b297-004499eb8b83
lens-shell>
```
Thanks,
Rajat Khandelwal
Re: Review Request 42291: LENS-923: CLI should allow query execution
without the prefix "query execute"
Posted by Amareshwari Sriramadasu <am...@apache.org>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/42291/#review114944
-----------------------------------------------------------
lens-cli/src/main/java/org/apache/lens/cli/commands/LensQueryCommands.java (line 81)
<https://reviews.apache.org/r/42291/#comment175768>
Mention it is launching a cube query.
- Amareshwari Sriramadasu
On Jan. 14, 2016, 8:10 a.m., Rajat Khandelwal wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/42291/
> -----------------------------------------------------------
>
> (Updated Jan. 14, 2016, 8:10 a.m.)
>
>
> Review request for lens.
>
>
> Bugs: LENS-923
> https://issues.apache.org/jira/browse/LENS-923
>
>
> Repository: lens
>
>
> Description
> -------
>
>
> Diffs
> -----
>
> lens-cli/src/main/java/org/apache/lens/cli/commands/BaseLensCommand.java 643772596c4724253333c0688a93ed621b4dba45
> lens-cli/src/main/java/org/apache/lens/cli/commands/LensLogResourceCommands.java 59b7355e832eac66b7054bcb33a3ec7e6dfb78ba
> lens-cli/src/main/java/org/apache/lens/cli/commands/LensQueryCommands.java a29600d25d89e73f26102ba609e04b73f4cb7c58
> src/site/apt/user/cli.apt 65380e680f1370820cf361457ad5286e6e95fd39
>
> Diff: https://reviews.apache.org/r/42291/diff/
>
>
> Testing
> -------
>
> ```
> $ bin/lens-cli.sh
> =======================================
> * *
> * Lens Client *
> * *
> =======================================
>
> Welcome to Lens Client
> lens-shell>select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2
> 14 Jan 2016 07:44:41 [Spring Shell] INFO cliLogger - Query handle: f255a717-2dfb-42fe-9a80-8308efae054c
> 14 Jan 2016 07:44:46 [Spring Shell] INFO cliLogger - User query: 'select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2' was submitted to hive/hive1
> 14 Jan 2016 07:44:46 [Spring Shell] INFO cliLogger - Driver query: 'INSERT OVERWRITE DIRECTORY "file:/tmp/lensreports/hdfsout/f255a717-2dfb-42fe-9a80-8308efae054c" SELECT ( sample_dim_chain . name ), sum(( sample_cube . measure2 )) FROM local_fact2 sample_cube join local_dim_table sample_dim_chain on sample_cube.dim3 = sample_dim_chain.id and (sample_dim_chain.dt = 'latest') WHERE ((((( sample_cube . dt ) = '2014-06-25' ) and (( sample_dim_chain . name ) != "first" )))) GROUP BY ( sample_dim_chain . name ) ORDER BY sample_dim_chain . name desc LIMIT 2 ' and Driver handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=75a2615a-8cac-45b3-b070-e284d415a8b4]
> 14 Jan 2016 07:44:56 [Spring Shell] INFO cliLogger - Query Status: Status : RUNNING
> Message : Query is running in HiveServer!
> Progress : 0.5
> Progress Message : [{"taskId":"Stage-6","type":"MAPREDLOCAL","externalHandle":"Stage-6","taskState":"FINISHED_STATE"},{"taskId":"Stage-2","type":"MAPRED","externalHandle":null,"taskState":"FINISHED_STATE"},{"taskId":"Stage-3","type":"MAPRED","externalHandle":null,"taskState":"RUNNING_STATE"},{"taskId":"Stage-0","type":"MOVE","externalHandle":"Stage-0","taskState":"UNKNOWN_STATE"}]
>
> 14 Jan 2016 07:44:58 [Spring Shell] INFO cliLogger - Query Status: Status : SUCCESSFUL
> Message : Query is successful!
> Progress : 1.0
> Result Available
> sample_dim_chain.name _c1
> Results of query stored at : file:/tmp/lensreports/hdfsout/f255a717-2dfb-42fe-9a80-8308efae054c processed in (17) seconds.
>
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2
> 14 Jan 2016 07:44:58 [Spring Shell] INFO cliLogger - Query handle: 894c458c-1555-4690-b2b0-ca3fc10b2eb8
> 14 Jan 2016 07:45:04 [Spring Shell] INFO cliLogger - User query: 'cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2' was submitted to hive/hive1
> 14 Jan 2016 07:45:04 [Spring Shell] INFO cliLogger - Driver query: 'INSERT OVERWRITE DIRECTORY "file:/tmp/lensreports/hdfsout/894c458c-1555-4690-b2b0-ca3fc10b2eb8" SELECT ( sample_dim_chain . name ), sum(( sample_cube . measure2 )) FROM local_fact2 sample_cube join local_dim_table sample_dim_chain on sample_cube.dim3 = sample_dim_chain.id and (sample_dim_chain.dt = 'latest') WHERE ((((( sample_cube . dt ) = '2014-06-25' ) and (( sample_dim_chain . name ) != "first" )))) GROUP BY ( sample_dim_chain . name ) ORDER BY sample_dim_chain . name desc LIMIT 2 ' and Driver handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=cfe47ca3-32fe-44c8-999a-138943150dee]
> 14 Jan 2016 07:45:14 [Spring Shell] INFO cliLogger - Query Status: Status : RUNNING
> Message : Query is running in HiveServer!
> Progress : 0.5
> Progress Message : [{"taskId":"Stage-6","type":"MAPREDLOCAL","externalHandle":"Stage-6","taskState":"FINISHED_STATE"},{"taskId":"Stage-2","type":"MAPRED","externalHandle":null,"taskState":"FINISHED_STATE"},{"taskId":"Stage-3","type":"MAPRED","externalHandle":null,"taskState":"RUNNING_STATE"},{"taskId":"Stage-0","type":"MOVE","externalHandle":"Stage-0","taskState":"UNKNOWN_STATE"}]
>
> 14 Jan 2016 07:45:14 [Spring Shell] INFO cliLogger - Query Status: Status : SUCCESSFUL
> Message : Query is successful!
> Progress : 1.0
> Result Available
> sample_dim_chain.name _c1
> Results of query stored at : file:/tmp/lensreports/hdfsout/894c458c-1555-4690-b2b0-ca3fc10b2eb8 processed in (15) seconds.
>
> lens-shell>select --query
>
> required --query: <query-string>; no default value
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async
> 918534fb-3eff-42da-a1dd-25f43a78d377
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async -0n
>
> optional --async: <async>; default if option present: 'true'; default if option not present: 'false'
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async --name
>
> optional --name: <query-name>; no default value
> lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async --name myquery
> 7009e162-f448-40a6-b297-004499eb8b83
> lens-shell>
> ```
>
>
> Thanks,
>
> Rajat Khandelwal
>
>
Re: Review Request 42291: LENS-923: CLI should allow query execution
without the prefix "query execute"
Posted by Rajat Khandelwal <ra...@gmail.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/42291/
-----------------------------------------------------------
(Updated Jan. 14, 2016, 1:40 p.m.)
Review request for lens.
Bugs: LENS-923
https://issues.apache.org/jira/browse/LENS-923
Repository: lens
Description
-------
Diffs (updated)
-----
lens-cli/src/main/java/org/apache/lens/cli/commands/BaseLensCommand.java 643772596c4724253333c0688a93ed621b4dba45
lens-cli/src/main/java/org/apache/lens/cli/commands/LensLogResourceCommands.java 59b7355e832eac66b7054bcb33a3ec7e6dfb78ba
lens-cli/src/main/java/org/apache/lens/cli/commands/LensQueryCommands.java a29600d25d89e73f26102ba609e04b73f4cb7c58
src/site/apt/user/cli.apt 65380e680f1370820cf361457ad5286e6e95fd39
Diff: https://reviews.apache.org/r/42291/diff/
Testing (updated)
-------
```
$ bin/lens-cli.sh
=======================================
* *
* Lens Client *
* *
=======================================
Welcome to Lens Client
lens-shell>select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2
14 Jan 2016 07:44:41 [Spring Shell] INFO cliLogger - Query handle: f255a717-2dfb-42fe-9a80-8308efae054c
14 Jan 2016 07:44:46 [Spring Shell] INFO cliLogger - User query: 'select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2' was submitted to hive/hive1
14 Jan 2016 07:44:46 [Spring Shell] INFO cliLogger - Driver query: 'INSERT OVERWRITE DIRECTORY "file:/tmp/lensreports/hdfsout/f255a717-2dfb-42fe-9a80-8308efae054c" SELECT ( sample_dim_chain . name ), sum(( sample_cube . measure2 )) FROM local_fact2 sample_cube join local_dim_table sample_dim_chain on sample_cube.dim3 = sample_dim_chain.id and (sample_dim_chain.dt = 'latest') WHERE ((((( sample_cube . dt ) = '2014-06-25' ) and (( sample_dim_chain . name ) != "first" )))) GROUP BY ( sample_dim_chain . name ) ORDER BY sample_dim_chain . name desc LIMIT 2 ' and Driver handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=75a2615a-8cac-45b3-b070-e284d415a8b4]
14 Jan 2016 07:44:56 [Spring Shell] INFO cliLogger - Query Status: Status : RUNNING
Message : Query is running in HiveServer!
Progress : 0.5
Progress Message : [{"taskId":"Stage-6","type":"MAPREDLOCAL","externalHandle":"Stage-6","taskState":"FINISHED_STATE"},{"taskId":"Stage-2","type":"MAPRED","externalHandle":null,"taskState":"FINISHED_STATE"},{"taskId":"Stage-3","type":"MAPRED","externalHandle":null,"taskState":"RUNNING_STATE"},{"taskId":"Stage-0","type":"MOVE","externalHandle":"Stage-0","taskState":"UNKNOWN_STATE"}]
14 Jan 2016 07:44:58 [Spring Shell] INFO cliLogger - Query Status: Status : SUCCESSFUL
Message : Query is successful!
Progress : 1.0
Result Available
sample_dim_chain.name _c1
Results of query stored at : file:/tmp/lensreports/hdfsout/f255a717-2dfb-42fe-9a80-8308efae054c processed in (17) seconds.
lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2
14 Jan 2016 07:44:58 [Spring Shell] INFO cliLogger - Query handle: 894c458c-1555-4690-b2b0-ca3fc10b2eb8
14 Jan 2016 07:45:04 [Spring Shell] INFO cliLogger - User query: 'cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2' was submitted to hive/hive1
14 Jan 2016 07:45:04 [Spring Shell] INFO cliLogger - Driver query: 'INSERT OVERWRITE DIRECTORY "file:/tmp/lensreports/hdfsout/894c458c-1555-4690-b2b0-ca3fc10b2eb8" SELECT ( sample_dim_chain . name ), sum(( sample_cube . measure2 )) FROM local_fact2 sample_cube join local_dim_table sample_dim_chain on sample_cube.dim3 = sample_dim_chain.id and (sample_dim_chain.dt = 'latest') WHERE ((((( sample_cube . dt ) = '2014-06-25' ) and (( sample_dim_chain . name ) != "first" )))) GROUP BY ( sample_dim_chain . name ) ORDER BY sample_dim_chain . name desc LIMIT 2 ' and Driver handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=cfe47ca3-32fe-44c8-999a-138943150dee]
14 Jan 2016 07:45:14 [Spring Shell] INFO cliLogger - Query Status: Status : RUNNING
Message : Query is running in HiveServer!
Progress : 0.5
Progress Message : [{"taskId":"Stage-6","type":"MAPREDLOCAL","externalHandle":"Stage-6","taskState":"FINISHED_STATE"},{"taskId":"Stage-2","type":"MAPRED","externalHandle":null,"taskState":"FINISHED_STATE"},{"taskId":"Stage-3","type":"MAPRED","externalHandle":null,"taskState":"RUNNING_STATE"},{"taskId":"Stage-0","type":"MOVE","externalHandle":"Stage-0","taskState":"UNKNOWN_STATE"}]
14 Jan 2016 07:45:14 [Spring Shell] INFO cliLogger - Query Status: Status : SUCCESSFUL
Message : Query is successful!
Progress : 1.0
Result Available
sample_dim_chain.name _c1
Results of query stored at : file:/tmp/lensreports/hdfsout/894c458c-1555-4690-b2b0-ca3fc10b2eb8 processed in (15) seconds.
lens-shell>select --query
required --query: <query-string>; no default value
lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async
918534fb-3eff-42da-a1dd-25f43a78d377
lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async -0n
optional --async: <async>; default if option present: 'true'; default if option not present: 'false'
lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async --name
optional --name: <query-name>; no default value
lens-shell>cube select sample_dim_chain.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim_chain.name != "first" order by sample_dim_chain.name desc limit 2 --async --name myquery
7009e162-f448-40a6-b297-004499eb8b83
lens-shell>
```
Thanks,
Rajat Khandelwal