[44/50] lens git commit: LENS-1472: Populate sample metastore on example db is failing

2018-02-05 Thread raju 
LENS-1472: Populate sample metastore on example db is failing


Project: http://git-wip-us.apache.org/repos/asf/lens/repo
Commit: http://git-wip-us.apache.org/repos/asf/lens/commit/dcbe18e6
Tree: http://git-wip-us.apache.org/repos/asf/lens/tree/dcbe18e6
Diff: http://git-wip-us.apache.org/repos/asf/lens/diff/dcbe18e6

Branch: refs/heads/master
Commit: dcbe18e6bd967cfc5abe14c8fb59bd0bddc2a753
Parents: 6d49513
Author: Rajat Khandelwal 
Authored: Tue Sep 5 22:49:00 2017 +0530
Committer: rajub 
Committed: Mon Jan 8 09:44:53 2018 +0800

--
 lens-dist/src/main/assembly/bin-dist.xml | 8 
 .../org/apache/lens/examples/PopulateSampleMetastore.java| 5 +
 .../main/java/org/apache/lens/examples/SampleMetastore.java  | 3 +++
 .../src/main/resources/sales-aggr-fact2-local4.data  | 2 ++
 4 files changed, 18 insertions(+)
--


http://git-wip-us.apache.org/repos/asf/lens/blob/dcbe18e6/lens-dist/src/main/assembly/bin-dist.xml
--
diff --git a/lens-dist/src/main/assembly/bin-dist.xml 
b/lens-dist/src/main/assembly/bin-dist.xml
index c3f8f17..36783b1 100644
--- a/lens-dist/src/main/assembly/bin-dist.xml
+++ b/lens-dist/src/main/assembly/bin-dist.xml
@@ -331,6 +331,14 @@
 
 
   ../lens-examples/src/main/resources/
+  
/client/examples/data/sales_aggr_fact2_local4
+  
+sales-aggr-fact2-local4*.data
+  
+
+
+
+  ../lens-examples/src/main/resources/
   /client/examples/data/sales_raw_local1
   
 sales-raw-local1*.data

http://git-wip-us.apache.org/repos/asf/lens/blob/dcbe18e6/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java
--
diff --git 
a/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java
 
b/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java
index 4fc15a6..7c8fd2c 100644
--- 
a/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java
+++ 
b/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java
@@ -43,6 +43,10 @@ public class PopulateSampleMetastore {
   private static final SimpleDateFormat FORMAT = new 
SimpleDateFormat("-MM-dd HH:mm:ss");
   private static final String NOW_TIME = FORMAT.format(DATE);
 
+  private static final String CREATE_QUERY = "CREATE TABLE if not exists 
mydb_sales_aggr_continuous_fact "
++ "(order_time timestamp, delivery_time timestamp, customer_id integer, 
product_id integer, promotion_id integer, "
++ "customer_city_id integer, production_city_id integer, delivery_city_id 
integer, unit_sales integer, "
++ "store_sales integer, store_cost integer, max_line_item_price integer, 
max_line_item_discount integer)";
   private static final String INSERT_QUERY = "INSERT INTO "
   + "mydb_sales_aggr_continuous_fact (order_time, delivery_time, 
customer_id, "
   + "product_id, promotion_id, customer_city_id, production_city_id, 
delivery_city_id, unit_sales, "
@@ -119,6 +123,7 @@ public class PopulateSampleMetastore {
 con.setAutoCommit(true);
 Statement statement = con.createStatement();
 try {
+  statement.execute(CREATE_QUERY);
   statement.execute(INSERT_QUERY);
 
 } finally {

http://git-wip-us.apache.org/repos/asf/lens/blob/dcbe18e6/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java
--
diff --git 
a/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java 
b/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java
index e5a397b..1aa993b 100644
--- a/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java
+++ b/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java
@@ -79,6 +79,9 @@ public class SampleMetastore {
   public void createCubes() throws JAXBException, IOException {
 createCube("sample-cube.xml");
 createCube("sales-cube.xml");
+createCube("cube11.xml");
+createCube("cube22.xml");
+createCube("cube33.xml");
   }
 
   private void createDimension(String dimensionSpec) {

http://git-wip-us.apache.org/repos/asf/lens/blob/dcbe18e6/lens-examples/src/main/resources/sales-aggr-fact2-local4.data
--
diff --git a/lens-examples/src/main/resources/sales-aggr-fact2-local4.data 
b/lens-examples/src/main/resources/sales-aggr-fact2-local4.data
new file mode 100644
index 000..407b097
--- /dev/null
+++ b/lens-examples/src/main/resources/sales-aggr-fact2-local4.data
@@ -0,0 +1,2 @@
+2015-04-13 03:00:00,2015-04-13 04:00:00,1,1,1,1,1,1,5,0
+2015-04-13

lens git commit: LENS-1472: Populate sample metastore on example db is failing

2018-01-07 Thread raju 
Repository: lens
Updated Branches:
  refs/heads/current-release-line 6d49513e0 -> dcbe18e6b


LENS-1472: Populate sample metastore on example db is failing


Project: http://git-wip-us.apache.org/repos/asf/lens/repo
Commit: http://git-wip-us.apache.org/repos/asf/lens/commit/dcbe18e6
Tree: http://git-wip-us.apache.org/repos/asf/lens/tree/dcbe18e6
Diff: http://git-wip-us.apache.org/repos/asf/lens/diff/dcbe18e6

Branch: refs/heads/current-release-line
Commit: dcbe18e6bd967cfc5abe14c8fb59bd0bddc2a753
Parents: 6d49513
Author: Rajat Khandelwal 
Authored: Tue Sep 5 22:49:00 2017 +0530
Committer: rajub 
Committed: Mon Jan 8 09:44:53 2018 +0800

--
 lens-dist/src/main/assembly/bin-dist.xml | 8 
 .../org/apache/lens/examples/PopulateSampleMetastore.java| 5 +
 .../main/java/org/apache/lens/examples/SampleMetastore.java  | 3 +++
 .../src/main/resources/sales-aggr-fact2-local4.data  | 2 ++
 4 files changed, 18 insertions(+)
--


http://git-wip-us.apache.org/repos/asf/lens/blob/dcbe18e6/lens-dist/src/main/assembly/bin-dist.xml
--
diff --git a/lens-dist/src/main/assembly/bin-dist.xml 
b/lens-dist/src/main/assembly/bin-dist.xml
index c3f8f17..36783b1 100644
--- a/lens-dist/src/main/assembly/bin-dist.xml
+++ b/lens-dist/src/main/assembly/bin-dist.xml
@@ -331,6 +331,14 @@
 
 
   ../lens-examples/src/main/resources/
+  
/client/examples/data/sales_aggr_fact2_local4
+  
+sales-aggr-fact2-local4*.data
+  
+
+
+
+  ../lens-examples/src/main/resources/
   /client/examples/data/sales_raw_local1
   
 sales-raw-local1*.data

http://git-wip-us.apache.org/repos/asf/lens/blob/dcbe18e6/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java
--
diff --git 
a/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java
 
b/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java
index 4fc15a6..7c8fd2c 100644
--- 
a/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java
+++ 
b/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java
@@ -43,6 +43,10 @@ public class PopulateSampleMetastore {
   private static final SimpleDateFormat FORMAT = new 
SimpleDateFormat("-MM-dd HH:mm:ss");
   private static final String NOW_TIME = FORMAT.format(DATE);
 
+  private static final String CREATE_QUERY = "CREATE TABLE if not exists 
mydb_sales_aggr_continuous_fact "
++ "(order_time timestamp, delivery_time timestamp, customer_id integer, 
product_id integer, promotion_id integer, "
++ "customer_city_id integer, production_city_id integer, delivery_city_id 
integer, unit_sales integer, "
++ "store_sales integer, store_cost integer, max_line_item_price integer, 
max_line_item_discount integer)";
   private static final String INSERT_QUERY = "INSERT INTO "
   + "mydb_sales_aggr_continuous_fact (order_time, delivery_time, 
customer_id, "
   + "product_id, promotion_id, customer_city_id, production_city_id, 
delivery_city_id, unit_sales, "
@@ -119,6 +123,7 @@ public class PopulateSampleMetastore {
 con.setAutoCommit(true);
 Statement statement = con.createStatement();
 try {
+  statement.execute(CREATE_QUERY);
   statement.execute(INSERT_QUERY);
 
 } finally {

http://git-wip-us.apache.org/repos/asf/lens/blob/dcbe18e6/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java
--
diff --git 
a/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java 
b/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java
index e5a397b..1aa993b 100644
--- a/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java
+++ b/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java
@@ -79,6 +79,9 @@ public class SampleMetastore {
   public void createCubes() throws JAXBException, IOException {
 createCube("sample-cube.xml");
 createCube("sales-cube.xml");
+createCube("cube11.xml");
+createCube("cube22.xml");
+createCube("cube33.xml");
   }
 
   private void createDimension(String dimensionSpec) {

http://git-wip-us.apache.org/repos/asf/lens/blob/dcbe18e6/lens-examples/src/main/resources/sales-aggr-fact2-local4.data
--
diff --git a/lens-examples/src/main/resources/sales-aggr-fact2-local4.data 
b/lens-examples/src/main/resources/sales-aggr-fact2-local4.data
new file mode 100644
index 000..407b097
--- /dev/null
+++

lens git commit: LENS-1472: Populate sample metastore on example db is failing

2017-09-05 Thread prongs 
Repository: lens
Updated Branches:
  refs/heads/master caf7a2c0b -> 2b86ac2b8


LENS-1472: Populate sample metastore on example db is failing


Project: http://git-wip-us.apache.org/repos/asf/lens/repo
Commit: http://git-wip-us.apache.org/repos/asf/lens/commit/2b86ac2b
Tree: http://git-wip-us.apache.org/repos/asf/lens/tree/2b86ac2b
Diff: http://git-wip-us.apache.org/repos/asf/lens/diff/2b86ac2b

Branch: refs/heads/master
Commit: 2b86ac2b83608efb95d9c89c10445c4a30f5
Parents: caf7a2c
Author: Rajat Khandelwal 
Authored: Tue Sep 5 22:49:00 2017 +0530
Committer: Rajat Khandelwal 
Committed: Tue Sep 5 22:49:00 2017 +0530

--
 lens-dist/src/main/assembly/bin-dist.xml | 8 
 .../org/apache/lens/examples/PopulateSampleMetastore.java| 5 +
 .../main/java/org/apache/lens/examples/SampleMetastore.java  | 3 +++
 .../src/main/resources/sales-aggr-fact2-local4.data  | 2 ++
 4 files changed, 18 insertions(+)
--


http://git-wip-us.apache.org/repos/asf/lens/blob/2b86ac2b/lens-dist/src/main/assembly/bin-dist.xml
--
diff --git a/lens-dist/src/main/assembly/bin-dist.xml 
b/lens-dist/src/main/assembly/bin-dist.xml
index c3f8f17..36783b1 100644
--- a/lens-dist/src/main/assembly/bin-dist.xml
+++ b/lens-dist/src/main/assembly/bin-dist.xml
@@ -331,6 +331,14 @@
 
 
   ../lens-examples/src/main/resources/
+  
/client/examples/data/sales_aggr_fact2_local4
+  
+sales-aggr-fact2-local4*.data
+  
+
+
+
+  ../lens-examples/src/main/resources/
   /client/examples/data/sales_raw_local1
   
 sales-raw-local1*.data

http://git-wip-us.apache.org/repos/asf/lens/blob/2b86ac2b/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java
--
diff --git 
a/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java
 
b/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java
index 4fc15a6..7c8fd2c 100644
--- 
a/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java
+++ 
b/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java
@@ -43,6 +43,10 @@ public class PopulateSampleMetastore {
   private static final SimpleDateFormat FORMAT = new 
SimpleDateFormat("-MM-dd HH:mm:ss");
   private static final String NOW_TIME = FORMAT.format(DATE);
 
+  private static final String CREATE_QUERY = "CREATE TABLE if not exists 
mydb_sales_aggr_continuous_fact "
++ "(order_time timestamp, delivery_time timestamp, customer_id integer, 
product_id integer, promotion_id integer, "
++ "customer_city_id integer, production_city_id integer, delivery_city_id 
integer, unit_sales integer, "
++ "store_sales integer, store_cost integer, max_line_item_price integer, 
max_line_item_discount integer)";
   private static final String INSERT_QUERY = "INSERT INTO "
   + "mydb_sales_aggr_continuous_fact (order_time, delivery_time, 
customer_id, "
   + "product_id, promotion_id, customer_city_id, production_city_id, 
delivery_city_id, unit_sales, "
@@ -119,6 +123,7 @@ public class PopulateSampleMetastore {
 con.setAutoCommit(true);
 Statement statement = con.createStatement();
 try {
+  statement.execute(CREATE_QUERY);
   statement.execute(INSERT_QUERY);
 
 } finally {

http://git-wip-us.apache.org/repos/asf/lens/blob/2b86ac2b/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java
--
diff --git 
a/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java 
b/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java
index e5a397b..1aa993b 100644
--- a/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java
+++ b/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java
@@ -79,6 +79,9 @@ public class SampleMetastore {
   public void createCubes() throws JAXBException, IOException {
 createCube("sample-cube.xml");
 createCube("sales-cube.xml");
+createCube("cube11.xml");
+createCube("cube22.xml");
+createCube("cube33.xml");
   }
 
   private void createDimension(String dimensionSpec) {

http://git-wip-us.apache.org/repos/asf/lens/blob/2b86ac2b/lens-examples/src/main/resources/sales-aggr-fact2-local4.data
--
diff --git a/lens-examples/src/main/resources/sales-aggr-fact2-local4.data 
b/lens-examples/src/main/resources/sales-aggr-fact2-local4.data
new file mode 100644
index 000..407b097
--- /dev/null
+++ b/lens-examples/src/main/resources/sales-aggr-fact2-local4.data
@@ -0,0