-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/33976/#review84679
-----------------------------------------------------------



lens-driver-jdbc/src/main/java/org/apache/lens/driver/jdbc/JDBCResultSet.java
<https://reviews.apache.org/r/33976/#comment136030>

    jdbc tests failing


- Rajat Khandelwal


On May 21, 2015, 3:06 p.m., Rajat Khandelwal wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/33976/
> -----------------------------------------------------------
> 
> (Updated May 21, 2015, 3:06 p.m.)
> 
> 
> Review request for lens.
> 
> 
> Bugs: LENS-26
>     https://issues.apache.org/jira/browse/LENS-26
> 
> 
> Repository: lens
> 
> 
> Description
> -------
> 
> option to download result into a file
> 
> 
> Diffs
> -----
> 
>   checkstyle/src/main/resources/checkstyle.xml 
> 236f977f58f41cd3fee2ebe8445f38dd4a1f0d3b 
>   lens-cli/src/main/java/org/apache/lens/cli/commands/BaseLensCommand.java 
> 8707fec5612a04e9a07ed9d5e38f342ef1f9114e 
>   lens-cli/src/main/java/org/apache/lens/cli/commands/LensCRUDCommand.java 
> 05922e394e5fea9e95e67d56d04697ebf438f48d 
>   
> lens-cli/src/main/java/org/apache/lens/cli/commands/LensCRUDStoragePartitionCommand.java
>  0d53e2107be116d4dbb855f247b57be0c1b97691 
>   lens-cli/src/main/java/org/apache/lens/cli/commands/LensQueryCommands.java 
> 64e9ca47c5c7df444cdd16b2d55bc738d6c945bc 
>   lens-cli/src/test/java/org/apache/lens/cli/TestLensQueryCommands.java 
> d7b63724f50dc392a5440ce8362b4eb6ca81f885 
>   lens-cli/src/test/java/org/apache/lens/cli/doc/TestGenerateCLIUserDoc.java 
> 508690743aa39011722cd56f9ad649d5c83de9c7 
>   lens-client/src/main/java/org/apache/lens/client/LensClient.java 
> 016e4ab1285582760b5da47b355402b747ea78e8 
>   lens-client/src/main/java/org/apache/lens/client/LensStatement.java 
> 5ce3a82926ed2bad6f29300d24a18b4cadbe0e4b 
>   lens-driver-hive/src/main/java/org/apache/lens/driver/hive/HiveDriver.java 
> 43985bad1571e6899679551674cea76e6196e8f8 
>   
> lens-driver-hive/src/main/java/org/apache/lens/driver/hive/HiveInMemoryResultSet.java
>  a953ec6a2117fa48e0a2ced4daa1f8d8d4e15731 
>   
> lens-driver-jdbc/src/main/java/org/apache/lens/driver/jdbc/JDBCResultSet.java 
> 36a48b9ea48eb89780f5c98dc396ae5f176d1bd4 
>   
> lens-server-api/src/main/java/org/apache/lens/server/api/driver/InMemoryResultSet.java
>  f11d8834d4010a1e7c616c6c3dd5ff90a6c577c5 
>   
> lens-server-api/src/test/java/org/apache/lens/server/api/driver/MockDriver.java
>  0f4e990512beab0fdb0b8e51c08b165e97494a9b 
>   
> lens-server/src/main/java/org/apache/lens/server/query/QueryExecutionServiceImpl.java
>  3bf180c9ab6f2a9fec6259848ebf65ecd147cfcf 
>   src/site/apt/user/cli.apt bd394972790792905cb21dd0da5894840f404d8e 
> 
> Diff: https://reviews.apache.org/r/33976/diff/
> 
> 
> Testing
> -------
> 
> Tests with lens persistence:
> 
> lens-shell>
> lens-shell>
> lens-shell>set lens.query.enable.persistent.resultset=true
> Set param succeeded
> lens-shell>set lens.query.enable.persistent.resultset.indriver=false
> Set param succeeded
> lens-shell>query execute cube select customer_city_name, store_cost from 
> sales where time_range_in(delivery_time, '2015-04-13-04', '2015-04-13-05') 
> --async true
> 751e983d-5a15-411b-948a-724ddaf26084
> lens-shell>
> lens-shell>query results 751e983d-5a15-411b-948a-724ddaf26084
> Result set metadata can be only queries for successful queries
> lens-shell>query results 751e983d-5a15-411b-948a-724ddaf26084
> customer_city.name    _c1
> Results of query stored at : 
> file:/tmp/lensreports/751e983d-5a15-411b-948a-724ddaf26084.csv 2 rows process 
> in (15) seconds.
> 
> lens-shell>query results 751e983d-5a15-411b-948a-724ddaf26084 --save_location 
> ~/
> Saved to /Users/rajat.khandelwal/751e983d-5a15-411b-948a-724ddaf26084.csv
> lens-shell>! cat 
> /Users/rajat.khandelwal/751e983d-5a15-411b-948a-724ddaf26084.csv
> command is:cat 
> /Users/rajat.khandelwal/751e983d-5a15-411b-948a-724ddaf26084.csv
> "Bangalore","0.0"
> "Hyderabad","2.0"
> lens-shell>
> 
> 
> Tests with driver persistence:
> 
> lens-shell>set lens.query.enable.persistent.resultset.indriver=true
> Set param succeeded
> lens-shell>set lens.query.enable.persistent.resultset=false
> Set param succeeded
> lens-shell>query execute cube select customer_city_name, store_cost from 
> sales where time_range_in(delivery_time, '2015-04-13-04', '2015-04-13-05') 
> --async true
> d022efaa-ff96-4252-a3c6-2f1d43c30730
> lens-shell>
> lens-shell>query results d022efaa-ff96-4252-a3c6-2f1d43c30730 --save_location 
> ~/
> Can't download the result because it's available in driver's persistence.
> customer_city.name    _c1
> Results of query stored at : 
> file:/tmp/lensreports/hdfsout/d022efaa-ff96-4252-a3c6-2f1d43c30730 -1 rows 
> process in (11) seconds.
> 
> lens-shell>! ls /tmp/lensreports/hdfsout/d022efaa-ff96-4252-a3c6-2f1d43c30730
> command is:ls /tmp/lensreports/hdfsout/d022efaa-ff96-4252-a3c6-2f1d43c30730
> 000000_0
> lens-shell>! cat 
> /tmp/lensreports/hdfsout/d022efaa-ff96-4252-a3c6-2f1d43c30730/000000_0
> command is:cat 
> /tmp/lensreports/hdfsout/d022efaa-ff96-4252-a3c6-2f1d43c30730/000000_0
> Bangalore0.0
> Hyderabad2.0
> lens-shell>
> 
> 
> With results in driver's memory, the tests have already been added to 
> TestLensQueryCommands.
> 
> JDBC tests are failing for now. I'm looking into it
> 
> 
> Thanks,
> 
> Rajat Khandelwal
> 
>

Reply via email to