You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@lens.apache.org by ra...@apache.org on 2018/01/08 01:45:30 UTC
lens git commit: LENS-1472: Populate sample metastore on example db
is failing
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 <pr...@apache.org>
Authored: Tue Sep 5 22:49:00 2017 +0530
Committer: rajub <ra...@lazada.com>
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 @@
<fileSet>
<directory>../lens-examples/src/main/resources/</directory>
+ <outputDirectory>/client/examples/data/sales_aggr_fact2_local4</outputDirectory>
+ <includes>
+ <include>sales-aggr-fact2-local4*.data</include>
+ </includes>
+ </fileSet>
+
+ <fileSet>
+ <directory>../lens-examples/src/main/resources/</directory>
<outputDirectory>/client/examples/data/sales_raw_local1</outputDirectory>
<includes>
<include>sales-raw-local1*.data</include>
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("yyyy-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 0000000..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 03:00:00,2015-04-13 04:00:00,2,1,2,2,2,1,8,2
\ No newline at end of file