[
https://issues.apache.org/jira/browse/LENS-21?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14214637#comment-14214637
]
Suma Shivaprasad commented on LENS-21:
--------------------------------------
C02H5P42DV13C02H5P42DV13:incubator-lens suma.shivaprasad (LENS-rewrite)$ grep
-B 7 "Tests run: " testout.txt
[INFO] Surefire report directory:
/Users/suma.shivaprasad/Documents/ws-user/incubator-lens/lens-api/target/surefire-reports
-------------------------------------------------------
T E S T S
-------------------------------------------------------
Running org.apache.lens.doc.TestGenerateConfigDoc
Configuring TestNG with: TestNG652Configurator
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.216 sec - in
org.apache.lens.doc.TestGenerateConfigDoc
Results :
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0
--
HQL:SELECT sum(( testcube . msr2 )) FROM TestQueryRewrite.c1_testfact2 testcube
WHERE (( testcube . dt ) between '2014-11-15-17' and '2014-11-17-16' or (
testcube . dt ) between '2014-11-11-17' and '2014-11-13-16' )
HQL:SELECT sum(( testcube . msr2 )) FROM TestQueryRewrite.c1_testfact2 testcube
WHERE ( testcube . dt ) between '2014-11-15 17:00:00' and '2014-11-17
16:00:00'
HQL:SELECT ( hourdim . full_hour ), sum(( testcube . msr2 )) FROM
TestQueryRewrite.c4_testfact testcube join TestQueryRewrite.c4_hourdimtbl
hourdim on testcube.test_time_dim_hour_id = hourdim.id WHERE ( hourdim .
full_hour ) between '2014-11-15 17:00:00' and '2014-11-17 16:00:00' GROUP
BY ( hourdim . full_hour )
HQL:SELECT sum(( testcube . msr2 )) FROM TestQueryRewrite.c4_testfact testcube
join TestQueryRewrite.c4_hourdimtbl hourdim on testcube.test_time_dim_hour_id =
hourdim.id WHERE ( hourdim . full_hour ) between '2014-11-15 17:00:00' and
'2014-11-17 16:00:00'
HQL:SELECT sum(( testcube . msr2 )) FROM TestQueryRewrite.c4_testfact testcube
join TestQueryRewrite.c4_hourdimtbl hourdim on testcube.test_time_dim_hour_id =
hourdim.id WHERE (((( testcube . cityid ) > 2 ) and ( hourdim . full_hour )
between '2014-11-15 17:00:00' and '2014-11-17 16:00:00' ) and (( testcube .
cityid ) != 5 ))
HQL:SELECT sum(( testcube . msr2 )) FROM TestQueryRewrite.c4_testfact testcube
join TestQueryRewrite.c4_hourdimtbl hourdim on testcube.test_time_dim_hour_id =
hourdim.id WHERE (( hourdim . full_hour ) between '2014-11-15 17:00:00' and
'2014-11-17 16:00:00' or ( hourdim . full_hour ) between '2014-11-11
17:00:00' and '2014-11-13 16:00:00' )
HQL:SELECT to_date(( hourdim . full_hour )), sum(( testcube . msr2 )) FROM
TestQueryRewrite.c4_testfact testcube join TestQueryRewrite.c4_hourdimtbl
hourdim on testcube.test_time_dim_hour_id = hourdim.id WHERE (( hourdim .
full_hour ) between '2014-11-15 17:00:00' and '2014-11-17 16:00:00' or (
hourdim . full_hour ) between '2014-11-11 17:00:00' and '2014-11-13
16:00:00' ) GROUP BY to_date(( hourdim . full_hour ))
Tests run: 107, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 902.807 sec -
in TestSuite
Results :
Tests run: 107, Failures: 0, Errors: 0, Skipped: 0
--
-------------------------------------------------------
Running org.apache.lens.storage.db.TestDBStorage
Configuring TestNG with: TestNG652Configurator
log4j:WARN No appenders could be found for logger
(org.apache.hadoop.util.Shell).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more
info.
2014-11-17 17:27:51.296 java[47746:1903] Unable to load realm mapping info from
SCDynamicStore
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 34.894 sec - in
org.apache.lens.storage.db.TestDBStorage
Results :
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0
--
2014-11-17 17:28:42,894 (main) [DEBUG -
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe.initialize(LazySimpleSerDe.java:200)]
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with:
columnNames=[firstcol, secondcol, thirdcol, fourthcol, fifthcol, sixthcol,
seventhcol] columnTypes=[int, string, varchar(20), char(15), array<tinyint>,
struct<a:int,b:varchar(10)>, map<int,char(10)>] separator=[[B@6c0ec436]
nullstring=\N lastColumnTakesRest=false
2014-11-17 17:28:42,895 (main) [DEBUG -
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe.initialize(LazySimpleSerDe.java:200)]
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with:
columnNames=[firstcol, secondcol, thirdcol, fourthcol, fifthcol, sixthcol,
seventhcol] columnTypes=[string, string, string, string, string, string,
string] separator=[[B@3d73eca6] nullstring=\N lastColumnTakesRest=false
2014-11-17 17:28:43,177 (main) [DEBUG -
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe.initialize(LazySimpleSerDe.java:200)]
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with:
columnNames=[firstcol, secondcol, thirdcol, fourthcol, fifthcol, sixthcol,
seventhcol] columnTypes=[int, string, varchar(20), char(15), array<tinyint>,
struct<a:int,b:varchar(10)>, map<int,char(10)>] separator=[[B@1d162212]
nullstring=\N lastColumnTakesRest=false
2014-11-17 17:28:43,180 (main) [DEBUG -
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe.initialize(LazySimpleSerDe.java:200)]
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with:
columnNames=[firstcol, secondcol, thirdcol, fourthcol, fifthcol, sixthcol,
seventhcol] columnTypes=[string, string, string, string, string, string,
string] separator=[[B@1816daa9] nullstring=\N lastColumnTakesRest=false
Setup outputs done
2014-11-17 17:28:43,260 (main) [DEBUG -
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe.initialize(LazySimpleSerDe.java:200)]
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with:
columnNames=[firstcol, secondcol, thirdcol, fourthcol, fifthcol, sixthcol,
seventhcol] columnTypes=[int, string, varchar(20), char(15), array<tinyint>,
struct<a:int,b:varchar(10)>, map<int,char(10)>] separator=[[B@7f342545]
nullstring=\N lastColumnTakesRest=false
2014-11-17 17:28:43,263 (main) [DEBUG -
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe.initialize(LazySimpleSerDe.java:200)]
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with:
columnNames=[firstcol, secondcol, thirdcol, fourthcol, fifthcol, sixthcol,
seventhcol] columnTypes=[string, string, string, string, string, string,
string] separator=[[B@387b1641] nullstring=\N lastColumnTakesRest=false
Tests run: 29, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 17.07 sec - in
TestSuite
Results :
Tests run: 29, Failures: 0, Errors: 0, Skipped: 0
--
2014-11-17 17:34:59,469 (main) [INFO -
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.logAuditEvent(HiveMetaStore.java:306)]
ugi=suma.shivaprasad ip=unknown-ip-addr cmd=get_all_tables:
db=testremotehivedriver
2014-11-17 17:34:59,470 (main) [INFO -
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.logInfo(HiveMetaStore.java:624)]
0: get_functions: db=testremotehivedriver pat=*
2014-11-17 17:34:59,482 (main) [INFO -
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.logAuditEvent(HiveMetaStore.java:306)]
ugi=suma.shivaprasad ip=unknown-ip-addr cmd=get_functions:
db=testremotehivedriver pat=*
2014-11-17 17:34:59,493 (main) [INFO -
org.apache.hadoop.hive.metastore.ObjectStore.dropDatabase(ObjectStore.java:551)]
Dropping database testremotehivedriver along with all tables
2014-11-17 17:34:59,541 (main) [INFO -
org.apache.hadoop.hive.metastore.HiveMetaStoreFsImpl.deleteDir(HiveMetaStoreFsImpl.java:40)]
deleting file:/tmp/hive/warehouse/testremotehivedriver.db
2014-11-17 17:34:59,542 (main) [INFO -
org.apache.hadoop.fs.TrashPolicyDefault.initialize(TrashPolicyDefault.java:92)]
Namenode trash configuration: Deletion interval = 0 minutes, Emptier interval =
0 minutes.
2014-11-17 17:34:59,581 (main) [INFO -
org.apache.hadoop.hive.metastore.HiveMetaStoreFsImpl.deleteDir(HiveMetaStoreFsImpl.java:50)]
Deleted the diretory file:/tmp/hive/warehouse/testremotehivedriver.db
Tests run: 25, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 361.244 sec -
in TestSuite
Results :
Tests run: 25, Failures: 0, Errors: 0, Skipped: 0
--
T E S T S
-------------------------------------------------------
Running TestSuite
Configuring TestNG with: TestNG652Configurator
log4j:WARN No appenders could be found for logger
(org.apache.lens.driver.impala.ImpalaDriver).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more
info.
Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 5.747 sec - in
TestSuite
Results :
Tests run: 8, Failures: 0, Errors: 0, Skipped: 0
--
at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
at org.hsqldb.ParserCommand.compilePart(Unknown Source)
at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
at org.hsqldb.Session.executeDirectStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 10 more
Driver closed!
Tests run: 23, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 45.036 sec -
in TestSuite
Results :
Tests run: 23, Failures: 0, Errors: 0, Skipped: 0
--
2014-11-17 18:02:50,968 (main) [INFO -
org.apache.hive.service.AbstractService.stop(AbstractService.java:125)]
Service:SessionManager is stopped.
1539256 [main] INFO org.apache.hive.service.AbstractService -
Service:SessionManager is stopped.
2014-11-17 18:02:50,969 (main) [INFO -
org.apache.hive.service.AbstractService.stop(AbstractService.java:125)]
Service:CLIService is stopped.
1539257 [main] INFO org.apache.hive.service.AbstractService -
Service:CLIService is stopped.
2014-11-17 18:02:50,969 (main) [INFO -
org.apache.hive.service.AbstractService.stop(AbstractService.java:125)]
Service:HiveServer2 is stopped.
1539257 [main] INFO org.apache.hive.service.AbstractService -
Service:HiveServer2 is stopped.
Remote hive server stopped!
Tests run: 68, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1,544.871 sec
- in TestSuite
Results :
Tests run: 68, Failures: 0, Errors: 0, Skipped: 0
--
[INFO] Surefire report directory:
/Users/suma.shivaprasad/Documents/ws-user/incubator-lens/lens-client/target/surefire-reports
-------------------------------------------------------
T E S T S
-------------------------------------------------------
Running org.apache.lens.jdbc.JDBCUrlParserTest
Configuring TestNG with: TestNG652Configurator
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1.885 sec - in
org.apache.lens.jdbc.JDBCUrlParserTest
Results :
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0
--
2014-11-17 18:08:34,512 (main) [INFO -
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.logInfo(HiveMetaStore.java:624)]
0: Metastore shutdown complete.
2014-11-17 18:08:34,513 (main) [INFO -
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.logAuditEvent(HiveMetaStore.java:306)]
ugi=suma.shivaprasad ip=unknown-ip-addr cmd=Metastore shutdown
complete.
2014-11-17 18:08:34,513 (main) [INFO -
org.apache.hive.service.AbstractService.stop(AbstractService.java:125)]
Service:OperationManager is stopped.
2014-11-17 18:08:34,513 (main) [INFO -
org.apache.hive.service.AbstractService.stop(AbstractService.java:125)]
Service:SessionManager is stopped.
2014-11-17 18:08:34,514 (main) [INFO -
org.apache.hive.service.AbstractService.stop(AbstractService.java:125)]
Service:CLIService is stopped.
2014-11-17 18:08:34,515 (main) [INFO -
org.apache.hive.service.AbstractService.stop(AbstractService.java:125)]
Service:HiveServer2 is stopped.
Remote hive server stopped!
Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 277.921 sec -
in TestSuite
--
at
java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:379)
at
org.glassfish.jersey.client.HttpUrlConnector._apply(HttpUrlConnector.java:296)
at
org.glassfish.jersey.client.HttpUrlConnector.apply(HttpUrlConnector.java:203)
... 13 more
Results :
Tests run: 12, Failures: 0, Errors: 0, Skipped: 0
> Minor refactoring changes in Query Rewriter interface
> ------------------------------------------------------
>
> Key: LENS-21
> URL: https://issues.apache.org/jira/browse/LENS-21
> Project: Apache Lens
> Issue Type: Improvement
> Components: api
> Affects Versions: 2.0
> Reporter: Suma Shivaprasad
> Assignee: Suma Shivaprasad
> Fix For: 2.0
>
> Attachments: LENS-34.patch
>
>
> QueryRewrite interface needs to be moved into server-api and some minor
> method signature changes
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
