You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@lens.apache.org by am...@apache.org on 2015/04/21 18:05:21 UTC
incubator-lens git commit: LENS-243 : Add smoke test as a part of
lens-regression (Arshad Matin via amareshwari)
Repository: incubator-lens
Updated Branches:
refs/heads/master be2739a87 -> b46e9f6de
LENS-243 : Add smoke test as a part of lens-regression (Arshad Matin via amareshwari)
Project: http://git-wip-us.apache.org/repos/asf/incubator-lens/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-lens/commit/b46e9f6d
Tree: http://git-wip-us.apache.org/repos/asf/incubator-lens/tree/b46e9f6d
Diff: http://git-wip-us.apache.org/repos/asf/incubator-lens/diff/b46e9f6d
Branch: refs/heads/master
Commit: b46e9f6deff0def07360d118f59332fa3e68c993
Parents: be2739a
Author: Arshad Matin <ar...@gmail.com>
Authored: Tue Apr 21 21:35:08 2015 +0530
Committer: Amareshwari Sriramadasu <am...@apache.org>
Committed: Tue Apr 21 21:35:08 2015 +0530
----------------------------------------------------------------------
lens-regression/pom.xml | 13 +-
.../core/testHelper/BaseTestClass.java | 23 +
.../org/apache/lens/regression/util/Util.java | 118 ++
.../src/main/resources/lens.properties | 9 +
.../lens/regression/sanity/ITSmokeTest.java | 124 ++
lens-regression/src/test/resources/result.data | 1517 ++++++++++++++++++
pom.xml | 19 +-
7 files changed, 1818 insertions(+), 5 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-lens/blob/b46e9f6d/lens-regression/pom.xml
----------------------------------------------------------------------
diff --git a/lens-regression/pom.xml b/lens-regression/pom.xml
index b5e0391..037b2e9 100644
--- a/lens-regression/pom.xml
+++ b/lens-regression/pom.xml
@@ -39,7 +39,18 @@
<artifactId>lens-api</artifactId>
<version>${project.version}</version>
</dependency>
-
+ <dependency>
+ <groupId>log4j</groupId>
+ <artifactId>log4j</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>com.jcraft</groupId>
+ <artifactId>jsch</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>org.testng</groupId>
+ <artifactId>testng</artifactId>
+ </dependency>
</dependencies>
</project>
http://git-wip-us.apache.org/repos/asf/incubator-lens/blob/b46e9f6d/lens-regression/src/main/java/org/apache/lens/regression/core/testHelper/BaseTestClass.java
----------------------------------------------------------------------
diff --git a/lens-regression/src/main/java/org/apache/lens/regression/core/testHelper/BaseTestClass.java b/lens-regression/src/main/java/org/apache/lens/regression/core/testHelper/BaseTestClass.java
new file mode 100644
index 0000000..2985af4
--- /dev/null
+++ b/lens-regression/src/main/java/org/apache/lens/regression/core/testHelper/BaseTestClass.java
@@ -0,0 +1,23 @@
+/**
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+package org.apache.lens.regression.core.testHelper;
+
+public class BaseTestClass {
+
+}
http://git-wip-us.apache.org/repos/asf/incubator-lens/blob/b46e9f6d/lens-regression/src/main/java/org/apache/lens/regression/util/Util.java
----------------------------------------------------------------------
diff --git a/lens-regression/src/main/java/org/apache/lens/regression/util/Util.java b/lens-regression/src/main/java/org/apache/lens/regression/util/Util.java
new file mode 100644
index 0000000..2d03af6
--- /dev/null
+++ b/lens-regression/src/main/java/org/apache/lens/regression/util/Util.java
@@ -0,0 +1,118 @@
+/**
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+package org.apache.lens.regression.util;
+
+import java.io.*;
+import java.util.Properties;
+
+
+import org.apache.log4j.Logger;
+
+import com.jcraft.jsch.ChannelExec;
+import com.jcraft.jsch.JSch;
+import com.jcraft.jsch.JSchException;
+import com.jcraft.jsch.Session;
+
+public class Util {
+
+ private Util() {
+
+ }
+
+ private static final Logger LOGGER = Logger.getLogger(Util.class);
+ private static final String PROPERTY_FILE = "lens.properties";
+ private static Properties properties;
+
+ public static Properties getPropertiesObj(String filename) {
+ try {
+ if (properties == null) {
+ properties = new Properties();
+ LOGGER.info("filename: " + filename);
+ InputStream confStream = Util.class.getResourceAsStream("/" + filename);
+ properties.load(confStream);
+ confStream.close();
+ }
+ return properties;
+
+ } catch (IOException e) {
+ LOGGER.info(e.getStackTrace());
+ }
+ return null;
+ }
+
+ public static String getProperty(String property) {
+ Properties prop = Util.getPropertiesObj(PROPERTY_FILE);
+ return prop.getProperty(property);
+ }
+
+ public static String runRemoteCommand(String command) throws JSchException, IOException {
+ StringBuilder outputBuffer = new StringBuilder();
+ StringBuilder print = new StringBuilder();
+
+ String userName = Util.getProperty("lens.remote.username");
+ String host = Util.getProperty("lens.remote.host");
+ String password = Util.getProperty("lens.remote.password");
+
+ LOGGER.info("Running command : " + command + " on host : " + host + " with user as " + userName);
+
+ JSch jsch = new JSch();
+ Session session = jsch.getSession(userName, host, 22);
+ session.setPassword(password);
+
+ Properties config = new Properties();
+ config.put("StrictHostKeyChecking", "no");
+
+ session.setServerAliveInterval(10000);
+ session.setConfig(config);
+ session.connect(0);
+
+ ChannelExec channel = (ChannelExec) session.openChannel("exec");
+ InputStream commandOutput = channel.getInputStream();
+
+ channel.setCommand(command);
+ channel.connect();
+ int readByte = commandOutput.read();
+ char toAppend = ' ';
+ while (readByte != 0xffffffff) {
+ toAppend = (char) readByte;
+ outputBuffer.append(toAppend);
+ readByte = commandOutput.read();
+ if (toAppend == '\n') {
+ LOGGER.info(print.toString());
+ print = new StringBuilder();
+ } else {
+ print.append(toAppend);
+ }
+ }
+ channel.disconnect();
+ session.disconnect();
+ return outputBuffer.toString();
+ }
+
+ public static void writeFile(String fileName, String str) {
+ try {
+ PrintWriter out = new PrintWriter(new BufferedWriter(new FileWriter(fileName)));
+ out.println(str);
+ out.close();
+ } catch (IOException e) {
+ LOGGER.info("File Exception : " + e);
+ }
+ }
+
+}
http://git-wip-us.apache.org/repos/asf/incubator-lens/blob/b46e9f6d/lens-regression/src/main/resources/lens.properties
----------------------------------------------------------------------
diff --git a/lens-regression/src/main/resources/lens.properties b/lens-regression/src/main/resources/lens.properties
new file mode 100644
index 0000000..de00410
--- /dev/null
+++ b/lens-regression/src/main/resources/lens.properties
@@ -0,0 +1,9 @@
+lens.baseurl=
+lens.adminurl=
+lens.username=
+lens.password=
+lens.server.dir=/usr/local/lens/server/
+lens.client.dir=/usr/local/lens/client/
+lens.remote.host=
+lens.remote.username=
+lens.remote.password=
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-lens/blob/b46e9f6d/lens-regression/src/test/java/org/apache/lens/regression/sanity/ITSmokeTest.java
----------------------------------------------------------------------
diff --git a/lens-regression/src/test/java/org/apache/lens/regression/sanity/ITSmokeTest.java b/lens-regression/src/test/java/org/apache/lens/regression/sanity/ITSmokeTest.java
new file mode 100644
index 0000000..7f462a9
--- /dev/null
+++ b/lens-regression/src/test/java/org/apache/lens/regression/sanity/ITSmokeTest.java
@@ -0,0 +1,124 @@
+/**
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+package org.apache.lens.regression.sanity;
+
+import java.io.BufferedReader;
+import java.io.File;
+import java.io.FileReader;
+import java.io.IOException;
+import java.lang.reflect.Method;
+
+import org.apache.lens.regression.core.testHelper.BaseTestClass;
+import org.apache.lens.regression.util.Util;
+
+import org.apache.log4j.Logger;
+
+import org.testng.Assert;
+import org.testng.annotations.BeforeMethod;
+import org.testng.annotations.Test;
+
+import com.jcraft.jsch.JSchException;
+
+public class ITSmokeTest extends BaseTestClass {
+
+ private static final Logger LOGGER = Logger.getLogger(ITSmokeTest.class);
+ private final String resourceDir = "src/test/resources";
+ private final String resultFile = resourceDir + "/result.data";
+ private final String smokeOutput = resourceDir + "/output.txt";
+ private final String clientDir = Util.getProperty("lens.client.dir");
+ private final String dbName = "smoketest";
+
+ @BeforeMethod(alwaysRun = true)
+ public void setUp(Method method) throws Exception {
+ LOGGER.info("Test Name: " + method.getName());
+ }
+
+ @Test(enabled = true, groups = {"integration"})
+ public void smokeTest() throws Exception {
+
+ String exampleScript = clientDir + "/bin/run-examples.sh";
+ String sampleMetastoreCommand = "bash " + exampleScript + " sample-metastore -db " + dbName;
+ String populateMetastoreCommand = "bash " + exampleScript + " populate-metastore -db " + dbName;
+ String runQueriesCommand = "bash " + exampleScript + " runqueries -db " + dbName;
+
+ LOGGER.info("Creating schema : ");
+ String output = Util.runRemoteCommand(sampleMetastoreCommand);
+ System.out.println("Output : " + output);
+ LOGGER.info("Output : " + output);
+
+ LOGGER.info("Populating Metastore : ");
+ output = Util.runRemoteCommand(populateMetastoreCommand);
+ LOGGER.info("Output : " + output);
+
+ LOGGER.info("Running Queries in Background : ");
+ output = Util.runRemoteCommand("nohup " + runQueriesCommand + " > smoke.log 2>&1 &");
+ LOGGER.info("Output : " + output);
+
+ waitToComplete();
+
+ output = Util.runRemoteCommand("cat smoke.log");
+ LOGGER.info("Output : " + output);
+
+ Util.writeFile(smokeOutput, output);
+
+ Assert.assertTrue(output.contains("Successful queries 146"), "Some Queries Failed");
+ Assert.assertTrue(compareFile(smokeOutput, resultFile), "Result Validation Failed");
+ }
+
+ private void waitToComplete() throws IOException, JSchException, InterruptedException {
+ boolean loop = true;
+ while (loop) {
+ String output = Util.runRemoteCommand("ps -ef | grep org.apache.lens.examples.SampleQueries | grep -v \"grep\" ");
+ if (output.length() == 0) {
+ loop = false;
+ }
+ Thread.sleep(60000);
+ }
+
+ }
+
+ private boolean compareFile(String file1, String file2) throws IOException {
+ String skipDriverTime = "Driver run time in millis";
+ String skipTotalTime = "Total time for running examples(in millis)";
+ String skipTime = "Total time in millis";
+ BufferedReader reader1 = new BufferedReader(new FileReader(new File(file1)));
+ BufferedReader reader2 = new BufferedReader(new FileReader(new File(file2)));
+ boolean validate = true;
+ try {
+ String line1 = reader1.readLine();
+ String line2 = reader2.readLine();
+ while ((validate) && (line1 != null) && (line2 != null)) {
+ if (line1.contains(skipTime) || line1.contains(skipDriverTime) || line1.contains(skipTotalTime)) {
+ line1 = reader1.readLine();
+ line2 = reader2.readLine();
+ } else if (!line1.equalsIgnoreCase(line2)) {
+ validate = false;
+ } else {
+ line1 = reader1.readLine();
+ line2 = reader2.readLine();
+ }
+ }
+ } finally {
+ reader1.close();
+ reader2.close();
+ }
+ return validate;
+ }
+
+}
http://git-wip-us.apache.org/repos/asf/incubator-lens/blob/b46e9f6d/lens-regression/src/test/resources/result.data
----------------------------------------------------------------------
diff --git a/lens-regression/src/test/resources/result.data b/lens-regression/src/test/resources/result.data
new file mode 100644
index 0000000..f753157
--- /dev/null
+++ b/lens-regression/src/test/resources/result.data
@@ -0,0 +1,1517 @@
+Query:cube select id,name from sample_dim
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:2845
+Driver run time in millis:119
+Result:
+1 first
+2 second
+3 third
+--------------------
+Query:cube select id,name from sample_dim where name != 'first'
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:77
+Driver run time in millis:1
+Result:
+2 second
+3 third
+--------------------
+Query:cube select id,name from sample_dim order by name
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:82
+Driver run time in millis:1
+Result:
+1 first
+2 second
+3 third
+--------------------
+Query:cube select id,name from sample_dim order by name desc
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:121
+Driver run time in millis:1
+Result:
+3 third
+2 second
+1 first
+--------------------
+Query:cube select id,name from sample_dim where name != 'first' order by name
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:111
+Driver run time in millis:1
+Result:
+2 second
+3 third
+--------------------
+Query:cube select id,name from sample_dim where name != 'first' order by name desc
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:106
+Driver run time in millis:1
+Result:
+3 third
+2 second
+--------------------
+Query:cube select id,name from sample_dim limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:115
+Driver run time in millis:1
+Result:
+1 first
+2 second
+--------------------
+Query:cube select id,name from sample_dim order by name limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:78
+Driver run time in millis:3
+Result:
+1 first
+2 second
+--------------------
+Query:cube select id,name from sample_dim order by name desc limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:67
+Driver run time in millis:3
+Result:
+3 third
+2 second
+--------------------
+Query:cube select id,name from sample_dim where name != 'first' limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:67
+Driver run time in millis:1
+Result:
+2 second
+3 third
+--------------------
+Query:cube select id,name from sample_dim where name != 'first' order by name limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:108
+Driver run time in millis:1
+Result:
+2 second
+3 third
+--------------------
+Query:cube select id,name from sample_dim where name != 'first' order by name desc limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:99
+Driver run time in millis:1
+Result:
+3 third
+2 second
+--------------------
+Query:cube select count(id) from sample_dim
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:348
+Driver run time in millis:2
+Result:
+3
+--------------------
+Query:cube select count(id) from sample_dim group by name
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:90
+Driver run time in millis:1
+Result:
+first 1
+second 1
+third 1
+--------------------
+Query:cube select count(distinct id) from sample_dim
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:88
+Driver run time in millis:1
+Result:
+3
+--------------------
+Query:cube select sample_dim.name, sample_dim2.name from sample_dim
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:19344
+Driver run time in millis:19094
+Result:
+fifth fifteen
+six sixteen
+seven
+eight eighteen
+first eleven
+second twelve
+third thirteen
+fourth fourteen
+--------------------
+Query:cube select sample_dim.name, sample_dim2.name from sample_dim join sample_dim2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:17191
+Driver run time in millis:17066
+Result:
+six sixteen
+eight eighteen
+first eleven
+second twelve
+third thirteen
+fourth fourteen
+fifth fifteen
+--------------------
+Query:cube select sample_dim.name, sample_dim2.name from sample_dim left outer join sample_dim2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:19158
+Driver run time in millis:19088
+Result:
+fifth fifteen
+six sixteen
+seven
+eight eighteen
+first eleven
+second twelve
+third thirteen
+fourth fourteen
+--------------------
+Query:cube select sample_dim.name, sample_dim2.name from sample_dim right outer join sample_dim2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:17208
+Driver run time in millis:17146
+Result:
+six sixteen
+ seventeen
+eight eighteen
+ ninteen
+first eleven
+second twelve
+third thirteen
+fourth fourteen
+fifth fifteen
+--------------------
+Query:cube select sample_dim.name, sample_dim2.name from sample_dim full outer join sample_dim2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22267
+Driver run time in millis:22202
+Result:
+seven
+ ninteen
+second twelve
+fifth fifteen
+eight eighteen
+third thirteen
+six sixteen
+first eleven
+fourth fourteen
+ seventeen
+--------------------
+Query:cube select count(id) from sample_dim where name != "first"
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:21170
+Driver run time in millis:20130
+Result:
+6
+--------------------
+Query:cube select count(distinct id) from sample_dim where name != "first"
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:21164
+Driver run time in millis:20147
+Result:
+6
+--------------------
+Query:cube select sample_dim.name, sample_dim2.name from sample_dim where sample_dim.name != 'first'
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:19135
+Driver run time in millis:19078
+Result:
+fifth fifteen
+six sixteen
+seven
+eight eighteen
+second twelve
+third thirteen
+fourth fourteen
+--------------------
+Query:cube select id,name from sample_db_dim
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:101
+Driver run time in millis:1
+Result:
+1 first
+2 second
+3 third
+--------------------
+Query:cube select id,name from sample_db_dim where name != 'first'
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:50
+Driver run time in millis:1
+Result:
+2 second
+3 third
+--------------------
+Query:cube select id,name from sample_db_dim order by name
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:76
+Driver run time in millis:1
+Result:
+1 first
+2 second
+3 third
+--------------------
+Query:cube select id,name from sample_db_dim order by name desc
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:76
+Driver run time in millis:1
+Result:
+3 third
+2 second
+1 first
+--------------------
+Query:cube select id,name from sample_db_dim where name != 'first' order by name
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:41
+Driver run time in millis:1
+Result:
+2 second
+3 third
+--------------------
+Query:cube select id,name from sample_db_dim where name != 'first' order by name desc
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:83
+Driver run time in millis:1
+Result:
+3 third
+2 second
+--------------------
+Query:cube select id,name from sample_db_dim limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:49
+Driver run time in millis:1
+Result:
+1 first
+2 second
+--------------------
+Query:cube select id,name from sample_db_dim order by name limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:49
+Driver run time in millis:1
+Result:
+1 first
+2 second
+--------------------
+Query:cube select id,name from sample_db_dim order by name desc limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:96
+Driver run time in millis:2
+Result:
+3 third
+2 second
+--------------------
+Query:cube select id,name from sample_db_dim where name != 'first' limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:51
+Driver run time in millis:2
+Result:
+2 second
+3 third
+--------------------
+Query:cube select id,name from sample_db_dim where name != 'first' order by name limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:91
+Driver run time in millis:1
+Result:
+2 second
+3 third
+--------------------
+Query:cube select id,name from sample_db_dim where name != 'first' order by name desc limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:65
+Driver run time in millis:1
+Result:
+3 third
+2 second
+--------------------
+Query:cube select count(id) from sample_db_dim
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:69
+Driver run time in millis:1
+Result:
+3
+--------------------
+Query:cube select count(id) from sample_db_dim group by name
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:63
+Driver run time in millis:1
+Result:
+first 1
+second 1
+third 1
+--------------------
+Query:cube select count(distinct id) from sample_db_dim
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:97
+Driver run time in millis:1
+Result:
+3
+--------------------
+Query:select * from (cube select sample_dim.name name1, sample_dim2.name name2 from sample_dim where sample_dim.name != 'first') a
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:19196
+Driver run time in millis:19127
+Result:
+fifth fifteen
+six sixteen
+seven
+eight eighteen
+second twelve
+third thirteen
+fourth fourteen
+--------------------
+Query:drop table temp1
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:320
+Driver run time in millis:110
+--------------------
+Query:create table temp1 as cube select id,name from sample_dim
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:30459
+Driver run time in millis:30414
+--------------------
+Query:select * from temp1
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:168
+Driver run time in millis:33
+Result:
+5 fifth
+6 six
+7 seven
+ eight
+1 first
+2 second
+3 third
+4 fourth
+--------------------
+Query:insert overwrite local directory '/tmp/example-output' cube select id,name from sample_dim
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:14197
+Driver run time in millis:14153
+--------------------
+Query:insert overwrite local directory '/tmp/example-output2' ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH SERDEPROPERTIES ('serialization.null.format'='-NA-','field.delim'=',' ) STORED AS TEXTFILE cube select id,name from sample_dim
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:14224
+Driver run time in millis:14178
+--------------------
+Query:drop table temp2
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:303
+Driver run time in millis:102
+--------------------
+Query:create table temp2(id int, name string)
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:217
+Driver run time in millis:29
+--------------------
+Query:insert overwrite table temp2 cube select id,name from sample_dim
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:30437
+Driver run time in millis:30387
+--------------------
+Query:select * from temp2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:179
+Driver run time in millis:32
+Result:
+5 fifth
+6 six
+7 seven
+ eight
+1 first
+2 second
+3 third
+4 fourth
+--------------------
+Query:drop table temp3
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:238
+Driver run time in millis:106
+--------------------
+Query:create table temp3(id int, name string) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH SERDEPROPERTIES ('serialization.null.format'='-NA-','field.delim'=',' ) STORED AS TEXTFILE
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:148
+Driver run time in millis:31
+--------------------
+Query:insert overwrite table temp3 cube select id,name from sample_dim
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:30448
+Driver run time in millis:30408
+--------------------
+Query:select * from temp3
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:197
+Driver run time in millis:33
+Result:
+5 fifth
+6 six
+7 seven
+ eight
+1 first
+2 second
+3 third
+4 fourth
+--------------------
+Query:cube select name from city
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:98
+Driver run time in millis:1
+Result:
+Bangalore
+Hyderabad
+Austin
+San Fransisco
+--------------------
+Query:cube select name from city where population > 1000000
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:16178
+Driver run time in millis:16128
+Result:
+Bangalore
+Hyderabad
+--------------------
+Query:cube select name, poi from city
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:14191
+Driver run time in millis:14146
+Result:
+Bangalore ["Parks","Temples","Software companies"]
+Hyderabad ["Minars","Museums","Software companies"]
+Austin ["Lakes","University","Museums","Software companies"]
+San Francisco ["Golden gate bridge","Beaches","Software companies"]
+--------------------
+Query:cube select distinct category from product
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:89
+Driver run time in millis:0
+Result:
+Clothes
+Food
+Stationary
+Wearables
+--------------------
+Query:cube select id, description from product where weight > 100
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:58
+Driver run time in millis:1
+Result:
+1 Book
+3 Shirt
+4 Shoes
+5 Chocolates
+--------------------
+Query:cube select category, count(1) as `Number of products` from product
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:24244
+Driver run time in millis:24172
+Result:
+Clothes 1
+Stationary 2
+Food 1
+Wearables 1
+--------------------
+Query:cube select name, customer_city_name from customer
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:107
+Driver run time in millis:2
+Result:
+Ramu Bangalore
+Meena Hyderabad
+JohnX Austin
+Anju San Fransisco
+--------------------
+Query:cube select customer.name, customer_city.population from customer
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:17214
+Driver run time in millis:17165
+Result:
+Ramu 10000000
+Meena 11000000
+JohnX 800000
+Anju 800000
+--------------------
+Query:cube select measure2 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:21242
+Driver run time in millis:20164
+Result:
+3600
+--------------------
+Query:cube select measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:18232
+Driver run time in millis:18154
+Result:
+86400
+--------------------
+Query:cube select measure2 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-26-01')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:21197
+Driver run time in millis:20147
+Result:
+93600
+--------------------
+Query:cube select dim1, measure2 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22193
+Driver run time in millis:22143
+Result:
+21 100
+24 400
+27 700
+22 200
+25 500
+28 800
+23 300
+26 600
+--------------------
+Query:cube select dim1, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:21178
+Driver run time in millis:20143
+Result:
+21 2400
+24 9600
+27 16800
+22 4800
+25 12000
+28 19200
+23 7200
+26 14400
+--------------------
+Query:cube select dim1, measure2 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-26-01')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22224
+Driver run time in millis:22166
+Result:
+21 2600
+24 10400
+27 18200
+22 5200
+25 13000
+28 20800
+23 7800
+26 15600
+--------------------
+Query:cube select dim3, measure3 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22230
+Driver run time in millis:22165
+Result:
+3 300.0
+6 600.0
+1 100.0
+4 400.0
+7 700.0
+2 200.0
+5 500.0
+8 800.0
+--------------------
+Query:cube select dim3, measure3 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22202
+Driver run time in millis:22156
+Result:
+3 300.0
+6 600.0
+1 100.0
+4 400.0
+7 700.0
+2 200.0
+5 500.0
+8 800.0
+--------------------
+Query:cube select dim3, measure3 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-26-01')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22235
+Driver run time in millis:22176
+Result:
+3 300.0
+6 600.0
+1 100.0
+4 400.0
+7 700.0
+2 200.0
+5 500.0
+8 800.0
+--------------------
+Query:cube select sample_dim.name, measure4 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:25150
+Driver run time in millis:25102
+Result:
+ 800.0
+first 100.0
+fifth 500.0
+second 200.0
+six 600.0
+fourth 400.0
+seven 700.0
+third 300.0
+--------------------
+Query:cube select sample_dim.name, measure4 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:25242
+Driver run time in millis:25186
+Result:
+ 800.0
+first 100.0
+fifth 500.0
+second 200.0
+six 600.0
+fourth 400.0
+seven 700.0
+third 300.0
+--------------------
+Query:cube select sample_dim.name, measure4 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-26-01')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:25212
+Driver run time in millis:25144
+Result:
+ 800.0
+first 100.0
+fifth 500.0
+second 200.0
+six 600.0
+fourth 400.0
+seven 700.0
+third 300.0
+--------------------
+Query:cube select sample_dim.name, measure4 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00') order by sample_dim.name
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:45271
+Driver run time in millis:45214
+Result:
+ 800.0
+fifth 500.0
+first 100.0
+fourth 400.0
+second 200.0
+seven 700.0
+six 600.0
+third 300.0
+--------------------
+Query:cube select sample_dim.name, measure4 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') order by sample_dim.name
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:45369
+Driver run time in millis:45308
+Result:
+ 800.0
+fifth 500.0
+first 100.0
+fourth 400.0
+second 200.0
+seven 700.0
+six 600.0
+third 300.0
+--------------------
+Query:cube select sample_dim.name, measure4 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-26-01') order by sample_dim.name
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:45302
+Driver run time in millis:45235
+Result:
+ 800.0
+fifth 500.0
+first 100.0
+fourth 400.0
+second 200.0
+seven 700.0
+six 600.0
+third 300.0
+--------------------
+Query:cube select sample_dim.name, measure3 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00') and sample_dim.name != "first"
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:29245
+Driver run time in millis:29180
+Result:
+fifth 500.0
+second 200.0
+six 600.0
+fourth 400.0
+seven 700.0
+third 300.0
+--------------------
+Query:cube select sample_dim.name, measure3 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim.name != "first"
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:25207
+Driver run time in millis:25148
+Result:
+fifth 500.0
+second 200.0
+six 600.0
+fourth 400.0
+seven 700.0
+third 300.0
+--------------------
+Query:cube select sample_dim.name, measure3 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-26-01') and sample_dim.name != "first"
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:27279
+Driver run time in millis:27218
+Result:
+fifth 500.0
+second 200.0
+six 600.0
+fourth 400.0
+seven 700.0
+third 300.0
+--------------------
+Query:cube select sample_dim.name, measure2 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00') and sample_dim.name != "first" order by sample_dim.name
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:47365
+Driver run time in millis:47305
+Result:
+fifth 500
+fourth 400
+second 200
+seven 700
+six 600
+third 300
+--------------------
+Query:cube select sample_dim.name, measure2 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00') and sample_dim.name != "first" order by sample_dim.name desc
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:45309
+Driver run time in millis:45251
+Result:
+third 300
+six 600
+seven 700
+second 200
+fourth 400
+fifth 500
+--------------------
+Query:cube select sample_dim.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim.name != "first" order by sample_dim.name
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:45293
+Driver run time in millis:45246
+Result:
+fifth 12000
+fourth 9600
+second 4800
+seven 16800
+six 14400
+third 7200
+--------------------
+Query:cube select sample_dim.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim.name != "first" order by sample_dim.name desc
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:45695
+Driver run time in millis:45643
+Result:
+third 7200
+six 14400
+seven 16800
+second 4800
+fourth 9600
+fifth 12000
+--------------------
+Query:cube select sample_dim.name, measure2 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-26-01') and sample_dim.name != "first" order by sample_dim.name
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:47353
+Driver run time in millis:47292
+Result:
+fifth 13000
+fourth 10400
+second 5200
+seven 18200
+six 15600
+third 7800
+--------------------
+Query:cube select sample_dim.name, measure2 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-26-01') and sample_dim.name != "first" order by sample_dim.name desc
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:47315
+Driver run time in millis:47243
+Result:
+third 7800
+six 15600
+seven 18200
+second 5200
+fourth 10400
+fifth 13000
+--------------------
+Query:cube select sample_dim.name, measure4 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00') order by sample_dim.name limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:45276
+Driver run time in millis:45222
+Result:
+ 800.0
+fifth 500.0
+--------------------
+Query:cube select sample_dim.name, measure4 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') order by sample_dim.name limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:47256
+Driver run time in millis:47207
+Result:
+ 800.0
+fifth 500.0
+--------------------
+Query:cube select sample_dim.name, measure4 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-26-01') order by sample_dim.name limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:45480
+Driver run time in millis:45387
+Result:
+ 800.0
+fifth 500.0
+--------------------
+Query:cube select sample_dim.name, measure3 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00') and sample_dim.name != "first" limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:25177
+Driver run time in millis:25124
+Result:
+fifth 500.0
+second 200.0
+--------------------
+Query:cube select sample_dim.name, measure3 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim.name != "first" limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:25178
+Driver run time in millis:25117
+Result:
+fifth 500.0
+second 200.0
+--------------------
+Query:cube select sample_dim.name, measure3 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-26-01') and sample_dim.name != "first" limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:27174
+Driver run time in millis:27112
+Result:
+fifth 500.0
+second 200.0
+--------------------
+Query:cube select sample_dim.name, measure2 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00') and sample_dim.name != "first" order by sample_dim.name limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:45260
+Driver run time in millis:45209
+Result:
+fifth 500
+fourth 400
+--------------------
+Query:cube select sample_dim.name, measure2 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00') and sample_dim.name != "first" order by sample_dim.name desc limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:47409
+Driver run time in millis:47352
+Result:
+third 300
+six 600
+--------------------
+Query:cube select sample_dim.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim.name != "first" order by sample_dim.name limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:47291
+Driver run time in millis:47233
+Result:
+fifth 12000
+fourth 9600
+--------------------
+Query:cube select sample_dim.name, measure2 from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00') and sample_dim.name != "first" order by sample_dim.name desc limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:45300
+Driver run time in millis:45238
+Result:
+third 7200
+six 14400
+--------------------
+Query:cube select sample_dim.name, measure2 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-26-01') and sample_dim.name != "first" order by sample_dim.name limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:47285
+Driver run time in millis:47233
+Result:
+fifth 13000
+fourth 10400
+--------------------
+Query:cube select sample_dim.name, measure2 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-26-01') and sample_dim.name != "first" order by sample_dim.name desc limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:47310
+Driver run time in millis:47257
+Result:
+third 7800
+six 15600
+--------------------
+Query:cube select dim1, dim2, measure1, measure2 from sample_cube where time_range_in(dt, '2014-06-25-20', '2014-06-26-02')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22242
+Driver run time in millis:22176
+Result:
+21 11 100 100
+22 12 200 200
+23 13 300 300
+24 14 400 400
+25 15 500 500
+26 16 600 600
+27 17 700 700
+28 18 800 800
+21 11 100 100
+22 12 200 200
+23 13 300 300
+24 14 400 400
+25 15 500 500
+26 16 600 600
+27 17 700 700
+28 18 800 800
+21 11 100 100
+22 12 200 200
+23 13 300 300
+24 14 400 400
+25 15 500 500
+26 16 600 600
+27 17 700 700
+28 18 800 800
+21 11 100 100
+22 12 200 200
+23 13 300 300
+24 14 400 400
+25 15 500 500
+26 16 600 600
+27 17 700 700
+28 18 800 800
+21 11 100 100
+22 12 200 200
+23 13 300 300
+24 14 400 400
+25 15 500 500
+26 16 600 600
+27 17 700 700
+28 18 800 800
+21 11 100 100
+22 12 200 200
+23 13 300 300
+24 14 400 400
+25 15 500 500
+26 16 600 600
+27 17 700 700
+28 18 800 800
+--------------------
+Query:cube select dim1, dim2, measure1, measure2 from sample_cube where time_range_in(dt, '2014-06-25-20', '2014-06-26-02') order by dim2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:26226
+Driver run time in millis:26178
+Result:
+21 11 100 100
+21 11 100 100
+21 11 100 100
+21 11 100 100
+21 11 100 100
+21 11 100 100
+22 12 200 200
+22 12 200 200
+22 12 200 200
+22 12 200 200
+22 12 200 200
+22 12 200 200
+23 13 300 300
+23 13 300 300
+23 13 300 300
+23 13 300 300
+23 13 300 300
+23 13 300 300
+24 14 400 400
+24 14 400 400
+24 14 400 400
+24 14 400 400
+24 14 400 400
+24 14 400 400
+25 15 500 500
+25 15 500 500
+25 15 500 500
+25 15 500 500
+25 15 500 500
+25 15 500 500
+26 16 600 600
+26 16 600 600
+26 16 600 600
+26 16 600 600
+26 16 600 600
+26 16 600 600
+27 17 700 700
+27 17 700 700
+27 17 700 700
+27 17 700 700
+27 17 700 700
+27 17 700 700
+28 18 800 800
+28 18 800 800
+28 18 800 800
+28 18 800 800
+28 18 800 800
+28 18 800 800
+--------------------
+Query:cube select dim1, dim2, measure1, measure2 from sample_cube where time_range_in(dt, '2014-06-25-20', '2014-06-26-02') order by dim2 desc
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:26231
+Driver run time in millis:26183
+Result:
+28 18 800 800
+28 18 800 800
+28 18 800 800
+28 18 800 800
+28 18 800 800
+28 18 800 800
+27 17 700 700
+27 17 700 700
+27 17 700 700
+27 17 700 700
+27 17 700 700
+27 17 700 700
+26 16 600 600
+26 16 600 600
+26 16 600 600
+26 16 600 600
+26 16 600 600
+26 16 600 600
+25 15 500 500
+25 15 500 500
+25 15 500 500
+25 15 500 500
+25 15 500 500
+25 15 500 500
+24 14 400 400
+24 14 400 400
+24 14 400 400
+24 14 400 400
+24 14 400 400
+24 14 400 400
+23 13 300 300
+23 13 300 300
+23 13 300 300
+23 13 300 300
+23 13 300 300
+23 13 300 300
+22 12 200 200
+22 12 200 200
+22 12 200 200
+22 12 200 200
+22 12 200 200
+22 12 200 200
+21 11 100 100
+21 11 100 100
+21 11 100 100
+21 11 100 100
+21 11 100 100
+21 11 100 100
+--------------------
+Query:cube select dim1, dim2, measure1, measure2 from sample_cube where time_range_in(dt, '2014-06-25-20', '2014-06-26-02') limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22214
+Driver run time in millis:22171
+Result:
+21 11 100 100
+22 12 200 200
+--------------------
+Query:cube select dim1, dim2, measure1, measure2 from sample_cube where time_range_in(dt, '2014-06-25-20', '2014-06-26-02') order by dim2 limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:26249
+Driver run time in millis:26201
+Result:
+21 11 100 100
+21 11 100 100
+--------------------
+Query:cube select dim1, dim2, measure1, measure2 from sample_cube where time_range_in(dt, '2014-06-25-20', '2014-06-26-02') order by dim2 desc limit 2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:24233
+Driver run time in millis:24178
+Result:
+28 18 800 800
+28 18 800 800
+--------------------
+Query:cube select dim1, avg(measure2) from sample_cube where time_range_in(dt, '2014-06-25-20', '2014-06-26-02')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:28261
+Driver run time in millis:28216
+Result:
+21 100.0
+24 400.0
+27 700.0
+22 200.0
+25 500.0
+28 800.0
+23 300.0
+26 600.0
+--------------------
+Query:cube select dim3, min(measure3) from sample_cube where time_range_in(dt, '2014-06-25-20', '2014-06-26-02')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:28248
+Driver run time in millis:28204
+Result:
+3 300.0
+6 600.0
+1 100.0
+4 400.0
+7 700.0
+2 200.0
+5 500.0
+8 800.0
+--------------------
+Query:cube select dim1, sum(measure2) from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22220
+Driver run time in millis:22168
+Result:
+21 100
+24 400
+27 700
+22 200
+25 500
+28 800
+23 300
+26 600
+--------------------
+Query:cube select dim1, sum(measure2)from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22214
+Driver run time in millis:22168
+Result:
+21 2400
+24 9600
+27 16800
+22 4800
+25 12000
+28 19200
+23 7200
+26 14400
+--------------------
+Query:cube select dim1, sum(measure2) from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-26-01')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22220
+Driver run time in millis:22168
+Result:
+21 2600
+24 10400
+27 18200
+22 5200
+25 13000
+28 20800
+23 7800
+26 15600
+--------------------
+Query:cube select dim3, max(measure3) from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22222
+Driver run time in millis:22176
+Result:
+3 300.0
+6 600.0
+1 100.0
+4 400.0
+7 700.0
+2 200.0
+5 500.0
+8 800.0
+--------------------
+Query:cube select dim3, max(measure3) from sample_cube where time_range_in(dt, '2014-06-25-00', '2014-06-26-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22262
+Driver run time in millis:22190
+Result:
+3 300.0
+6 600.0
+1 100.0
+4 400.0
+7 700.0
+2 200.0
+5 500.0
+8 800.0
+--------------------
+Query:cube select dim3, max(measure3) from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-26-01')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22234
+Driver run time in millis:22168
+Result:
+3 300.0
+6 600.0
+1 100.0
+4 400.0
+7 700.0
+2 200.0
+5 500.0
+8 800.0
+--------------------
+Query:cube select sample_dim.name, measure4 from sample_cube join sample_dim where time_range_in(dt, '2014-06-24-23', '2014-06-25-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:27185
+Driver run time in millis:27136
+Result:
+first 100.0
+fifth 500.0
+second 200.0
+six 600.0
+fourth 400.0
+seven 700.0
+third 300.0
+--------------------
+Query:cube select sample_dim.name, measure4 from sample_cube left outer join sample_dim where time_range_in(dt, '2014-06-25-00', '2014-06-26-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:25189
+Driver run time in millis:25132
+Result:
+ 800.0
+first 100.0
+fifth 500.0
+second 200.0
+six 600.0
+fourth 400.0
+seven 700.0
+third 300.0
+--------------------
+Query:cube select sample_dim.name, measure4 from sample_cube right outer join sample_dim where time_range_in(dt, '2014-06-24-23', '2014-06-26-01')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:25208
+Driver run time in millis:25149
+Result:
+first 100.0
+fifth 500.0
+second 200.0
+six 600.0
+fourth 400.0
+seven 700.0
+third 300.0
+--------------------
+Query:cube select sample_dim.name, measure4 from sample_cube full outer join sample_dim where time_range_in(dt, '2014-06-24-23', '2014-06-26-01')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:48406
+Driver run time in millis:48295
+Result:
+ 800.0
+first 100.0
+fifth 500.0
+second 200.0
+six 600.0
+fourth 400.0
+seven 700.0
+third 300.0
+--------------------
+Query:select * from (cube select sample_dim.name, measure4 from sample_cube join sample_dim where time_range_in(dt, '2014-06-24-23', '2014-06-25-00') ) a
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:25210
+Driver run time in millis:25156
+Result:
+first 100.0
+fifth 500.0
+second 200.0
+six 600.0
+fourth 400.0
+seven 700.0
+third 300.0
+--------------------
+Query:drop table temp1
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:290
+Driver run time in millis:100
+--------------------
+Query:create table temp1 as cube select sample_dim.name, measure4 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00')
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:25352
+Driver run time in millis:25306
+--------------------
+Query:select * from temp1
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:207
+Driver run time in millis:52
+Result:
+ 800.0
+first 100.0
+fifth 500.0
+second 200.0
+six 600.0
+fourth 400.0
+seven 700.0
+third 300.0
+--------------------
+Query:insert overwrite local directory '/tmp/example-cube-output' cube select sample_dim.name, measure4 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00')
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:25179
+Driver run time in millis:25124
+--------------------
+Query:insert overwrite local directory '/tmp/example-cube-output2' ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH SERDEPROPERTIES ('serialization.null.format'='-NA-','field.delim'=',' ) STORED AS TEXTFILE cube select sample_dim.name, measure4 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00')
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:25188
+Driver run time in millis:25143
+--------------------
+Query:drop table temp2
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:290
+Driver run time in millis:97
+--------------------
+Query:create table temp2(name string, msr4 float)
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:218
+Driver run time in millis:36
+--------------------
+Query:insert overwrite table temp2 cube select sample_dim.name, measure4 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00')
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:25408
+Driver run time in millis:25364
+--------------------
+Query:select * from temp2
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:173
+Driver run time in millis:32
+Result:
+ 800.0
+first 100.0
+fifth 500.0
+second 200.0
+six 600.0
+fourth 400.0
+seven 700.0
+third 300.0
+--------------------
+Query:drop table temp3
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:215
+Driver run time in millis:95
+--------------------
+Query:create table temp3(name string, msr4 float) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH SERDEPROPERTIES ('serialization.null.format'='-NA-','field.delim'=',' ) STORED AS TEXTFILE
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:157
+Driver run time in millis:34
+--------------------
+Query:insert overwrite table temp3 cube select sample_dim.name, measure4 from sample_cube where time_range_in(dt, '2014-06-24-23', '2014-06-25-00')
+Status:SUCCESSFUL:Query is successful! - Result Not Available
+Total time in millis:25407
+Driver run time in millis:25361
+--------------------
+Query:select * from temp3
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:176
+Driver run time in millis:31
+Result:
+ 800.0
+first 100.0
+fifth 500.0
+second 200.0
+six 600.0
+fourth 400.0
+seven 700.0
+third 300.0
+--------------------
+Query:cube select product_id, store_sales from sales where time_range_in(order_time, '2015-04-11-00', '2015-04-13-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22294
+Driver run time in millis:22181
+Result:
+1 10.0
+2 16.0
+--------------------
+Query:cube select product_id, store_sales from sales where time_range_in(order_time, '2015-04-11-00', '2015-04-13-01')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22288
+Driver run time in millis:22207
+Result:
+1 15.0
+2 24.0
+--------------------
+Query:cube select product_id, store_sales from sales where time_range_in(order_time, '2015-04-12-00', '2015-04-13-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:78
+Driver run time in millis:3
+Result:
+1 5.0
+2 8.0
+--------------------
+Query:cube select product_id, store_sales from sales where time_range_in(order_time, '2015-04-13-00', '2015-04-13-02')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22247
+Driver run time in millis:22174
+Result:
+1 10.0
+2 24.0
+--------------------
+Query:cube select product_id, store_sales from sales where time_range_in(delivery_time, '2015-04-11-00', '2015-04-13-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22274
+Driver run time in millis:22167
+Result:
+1 10.0
+2 16.0
+--------------------
+Query:cube select product_id, store_sales from sales where time_range_in(delivery_time, '2015-04-12-00', '2015-04-13-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:97
+Driver run time in millis:1
+Result:
+1 5.0
+2 8.0
+--------------------
+Query:cube select promotion_sales, store_sales from sales where time_range_in(order_time, '2015-04-13-00', '2015-04-13-02')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:22243
+Driver run time in millis:22198
+Result:
+26.0 34.0
+--------------------
+Query:cube select promotion_sales, store_sales from sales where time_range_in(order_time, '2015-04-13-00', '2015-04-13-01')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:21184
+Driver run time in millis:20181
+Result:
+13.0 13.0
+--------------------
+Query:cube select customer_city_name, store_sales from sales where time_range_in(delivery_time, '2015-04-12-00', '2015-04-13-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:113
+Driver run time in millis:3
+Result:
+Bangalore 5.0
+Hyderabad 8.0
+--------------------
+Query:cube select customer_city_name, store_sales from sales where time_range_in(delivery_time, '2015-04-11-00', '2015-04-13-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:25276
+Driver run time in millis:25186
+Result:
+Bangalore 10.0
+Hyderabad 16.0
+--------------------
+Query:cube select customer_city_name, delivery_city.name, production_city.name, store_sales from sales where time_range_in(delivery_time, '2015-04-11-00', '2015-04-13-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:25399
+Driver run time in millis:25303
+Result:
+Bangalore Bangalore Bangalore 10.0
+Hyderabad Hyderabad Hyderabad 16.0
+--------------------
+Query:cube select product_details.color, store_sales from sales where time_range_in(order_time, '2015-04-11-00', '2015-04-13-00') and product_details.category='Stationary'
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:25351
+Driver run time in millis:25263
+Result:
+White 10.0
+Blue 16.0
+--------------------
+Query:cube select product_details.category, store_sales from sales where time_range_in(order_time, '2015-04-11-00', '2015-04-13-01')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:25417
+Driver run time in millis:25314
+Result:
+Stationary 39.0
+--------------------
+Query:cube select product_details.color, store_sales from sales where time_range_in(order_time, '2015-04-12-00', '2015-04-13-00')and product_details.category='Stationary'
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:117
+Driver run time in millis:7
+Result:
+White 5.0
+Blue 8.0
+--------------------
+Query:cube select product_details.category, store_sales from sales where time_range_in(order_time, '2015-04-11-00', '2015-04-13-01')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:25253
+Driver run time in millis:25164
+Result:
+Stationary 39.0
+--------------------
+Query:cube select product_details.category, store_sales from sales where time_range_in(order_time, '2015-04-12-00', '2015-04-13-00')
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:79
+Driver run time in millis:1
+Result:
+Stationary 13.0
+--------------------
+Query:cube select product_details.color, store_sales from sales where time_range_in(delivery_time, '2015-04-11-00', '2015-04-13-00') and product_details.category='Stationary'
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:25274
+Driver run time in millis:25206
+Result:
+White 10.0
+Blue 16.0
+--------------------
+Query:cube select product_details.color, store_sales from sales where time_range_in(delivery_time, '2015-04-12-00', '2015-04-13-00') and product_details.category='Stationary'
+Status:SUCCESSFUL:Query is successful! - Result Available
+Total time in millis:76
+Driver run time in millis:4
+Result:
+White 5.0
+Blue 8.0
+--------------------
+Successful queries 146 out of 146queries
+Total time for running examples(in millis) :3914655
http://git-wip-us.apache.org/repos/asf/incubator-lens/blob/b46e9f6d/pom.xml
----------------------------------------------------------------------
diff --git a/pom.xml b/pom.xml
index 2c31f99..a0744e4 100644
--- a/pom.xml
+++ b/pom.xml
@@ -60,6 +60,7 @@
<jackson.asl.version>1.9.13</jackson.asl.version>
<opencsv.version>2.3</opencsv.version>
+ <jsch.version>0.1.42</jsch.version>
<libthrift.version>0.9.0</libthrift.version>
@@ -412,6 +413,9 @@
<artifactId>maven-surefire-plugin</artifactId>
<version>${surefire.plugin.version}</version>
<configuration>
+ <excludes>
+ <exclude>**/IT*.java</exclude>
+ </excludes>
<failIfNoTests>false</failIfNoTests>
<forkedProcessTimeoutInSeconds>2400</forkedProcessTimeoutInSeconds>
</configuration>
@@ -1149,6 +1153,11 @@
<artifactId>opencsv</artifactId>
<version>${opencsv.version}</version>
</dependency>
+ <dependency>
+ <groupId>com.jcraft</groupId>
+ <artifactId>jsch</artifactId>
+ <version>${jsch.version}</version>
+ </dependency>
</dependencies>
</dependencyManagement>
@@ -1173,7 +1182,7 @@
<profiles>
<profile>
- <id>integration-tests</id>
+ <id>regression-tests</id>
<build>
<plugins>
<plugin>
@@ -1192,11 +1201,13 @@
<artifactId>maven-surefire-plugin</artifactId>
<configuration>
<includes>
- <!-- integration test would run with mvn clean install -P integration-tests -->
+ <!-- regression test would run with mvn clean install -P regression-tests -->
<include>**/IT*.java</include>
</includes>
- <forkedProcessTimeoutInSeconds>600</forkedProcessTimeoutInSeconds>
- <redirectTestOutputToFile>true</redirectTestOutputToFile>
+ <excludes>
+ <exclude>**/UT*.java</exclude>
+ </excludes>
+ <forkedProcessTimeoutInSeconds>6200</forkedProcessTimeoutInSeconds>
</configuration>
</plugin>
</plugins>