You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by Yash Sharma <ya...@gmail.com> on 2015/04/28 20:25:17 UTC
Error while trying examples script on lens
Hi All,
I am stumbling upon this error while trying out the examples on Lens. I
might be missing out something trivial - Hope if I can get any tips here.
Env Details:
(Ubuntu 14.04.2 LTS, Apache Maven 3.2.5, Java version: 1.7.0_75)
Thanks
Adding the error messages and Logs below:
--------------------------------------------------------------
yash@yash client $./bin/run-examples.sh populate-metastore
Adding partition from:dim1-local-part.xml failed
Adding partition from:dim2-local-part.xml failed
Adding partition from:dim4-local-part.xml failed
Created DB storages for dim_table3 and dim_table4
Exception in thread "main" javax.ws.rs.NotFoundException: HTTP 404 Not Found
at
org.glassfish.jersey.client.JerseyInvocation.convertToException(JerseyInvocation.java:913)
at
org.glassfish.jersey.client.JerseyInvocation.translate(JerseyInvocation.java:770)
at
org.glassfish.jersey.client.JerseyInvocation.access$500(JerseyInvocation.java:90)
at
org.glassfish.jersey.client.JerseyInvocation$2.call(JerseyInvocation.java:671)
at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
at org.glassfish.jersey.internal.Errors.process(Errors.java:228)
at
org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:422)
at
org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:667)
at
org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:423)
at
org.glassfish.jersey.client.JerseyInvocation$Builder.post(JerseyInvocation.java:326)
at
org.apache.lens.client.LensMetadataClient.addPartitionToFactTable(LensMetadataClient.java:842)
at
org.apache.lens.examples.PopulateSampleMetastore.createFactPartition(PopulateSampleMetastore.java:123)
at
org.apache.lens.examples.PopulateSampleMetastore.populateFactTables(PopulateSampleMetastore.java:133)
at
org.apache.lens.examples.PopulateSampleMetastore.populateAll(PopulateSampleMetastore.java:66)
at
org.apache.lens.examples.PopulateSampleMetastore.main(PopulateSampleMetastore.java:55)
------------------------------------------------------------------------------------
yash@yash client $./bin/run-examples.sh sample-metastore
Creating storage from:local-storage.xml failed,
reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
table
Creating storage from:local-cluster-storage.xml failed,
reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
table
Creating storage from:db-storage.xml failed,
reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
table
Creating cube from:sample-cube.xml failed,
reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
table
Creating dimension from:sample-dimension.xml failed,
reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
table
Creating dimension from:sample-dimension2.xml failed,
reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
table
Creating dimension from:sample-db-only-dimension.xml failed,
reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
table
Creating fact table from: fact1.xml failed,
reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
table
Creating fact table from: fact2.xml failed,
reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
table
Creating fact table from: rawfact.xml failed,
reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
table
Creating dim table from: dim_table.xml failed,
reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
table
Creating dim table from: dim_table2.xml failed,
reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
table
Creating dim table from: dim_table3.xmlfailed,
reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
table
Creating dim table from: dim_table4.xml failed,
reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
table
Created sample metastore!
Database:default
Storages:null
Cubes:null
Dimensions:null
Fact tables:null
Dimension tables:null
---------------------------------------------
LOGS: logs/lensclient.log
---------------------------------------------
28 Apr 2015 23:17:00,853 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE -
Checkpoint start
28 Apr 2015 23:17:00,854 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE -
checkpointClose start
28 Apr 2015 23:17:00,874 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE -
checkpointClose end
28 Apr 2015 23:17:00,879 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE -
Checkpoint end
28 Apr 2015 23:17:00,913 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE -
Database closed
28 Apr 2015 23:17:34,125 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE -
Database closed
Re: Error while trying examples script on lens
Posted by "amareshwarisr ." <am...@gmail.com>.
Yes. We can add for both the setup.
On Wed, Apr 29, 2015 at 10:50 AM, Yash Sharma <ya...@gmail.com> wrote:
> Thanks Rajat and Amreshwari -
> I was able to run the example scripts by changing permissions for
> /user/hive/warehouse.
>
> Amreshwari - I would like to start on LENS-527. I wonder if we need to add
> the changes for both conf & conf-pseudo-distr ?
>
> Regards
>
> Files:
> tools/conf-pseudo-distr/server/lens-site.xml
> tools/conf/server/lens-site.xml
>
>
> On Wed, Apr 29, 2015 at 9:52 AM, amareshwarisr . <am...@gmail.com>
> wrote:
>
> > Created https://issues.apache.org/jira/browse/LENS-527 for the issue. On
> > mac machines, usually we did not face the issue - so it was not seen.
> >
> > The configuration should go in lens-site.xml than hive-site.xml, as we do
> > not have hive-site.xml in server conf directory.
> >
> > Yash, feel free to pick it up and put changes required, if you can. This
> > would good one to start contributing.
> >
> > Thanks
> > Amareshwari
> >
> > On Wed, Apr 29, 2015 at 1:04 AM, Rajat Khandelwal <
> rajatgupta59@gmail.com>
> > wrote:
> >
> > > You have to change hive warehouse directory in server conf
> hive-site.xml
> > >
> > > It's right now inside /usr/hive/warehouse where you don't have
> > permissions
> > > right now.
> > >
> > > On Wed, Apr 29, 2015, 00:45 Yash Sharma <ya...@gmail.com> wrote:
> > >
> > > > Thanks Rajat,
> > > > I see the same errors when swapping the order of commands.
> > > > I can help you with the server logs though.
> > > >
> > > > https://gist.github.com/yssharma/8a5e367e73654e3b6ce9
> > > >
> > > > Regards
> > > >
> > > > On Wed, Apr 29, 2015 at 12:33 AM, Rajat Khandelwal <
> > > rajatgupta59@gmail.com
> > > > >
> > > > wrote:
> > > >
> > > > > Just to confirm, you have to do sample-metastore before and
> > > > > populate-metastore after.
> > > > >
> > > > > Given that, server logs would be more helpful for debugging.
> > > > >
> > > > > Just posting a quick reply before I try to reproduce the issue.
> > > > >
> > > > > On Tue, Apr 28, 2015 at 11:57 PM Yash Sharma <ya...@gmail.com>
> > > wrote:
> > > > >
> > > > > > Hi All,
> > > > > > I am stumbling upon this error while trying out the examples on
> > > Lens. I
> > > > > > might be missing out something trivial - Hope if I can get any
> tips
> > > > here.
> > > > > >
> > > > > > Env Details:
> > > > > > (Ubuntu 14.04.2 LTS, Apache Maven 3.2.5, Java version: 1.7.0_75)
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > > Adding the error messages and Logs below:
> > > > > >
> > > > > > --------------------------------------------------------------
> > > > > > yash@yash client $./bin/run-examples.sh populate-metastore
> > > > > > Adding partition from:dim1-local-part.xml failed
> > > > > > Adding partition from:dim2-local-part.xml failed
> > > > > > Adding partition from:dim4-local-part.xml failed
> > > > > > Created DB storages for dim_table3 and dim_table4
> > > > > > Exception in thread "main" javax.ws.rs.NotFoundException: HTTP
> 404
> > > Not
> > > > > > Found
> > > > > > at
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation.convertToException(JerseyInvocation.java:913)
> > > > > > at
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation.translate(JerseyInvocation.java:770)
> > > > > > at
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation.access$500(JerseyInvocation.java:90)
> > > > > > at
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation$2.call(JerseyInvocation.java:671)
> > > > > > at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
> > > > > > at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
> > > > > > at org.glassfish.jersey.internal.Errors.process(Errors.java:228)
> > > > > > at
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:422)
> > > > > > at
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:667)
> > > > > > at
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:423)
> > > > > > at
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation$Builder.post(JerseyInvocation.java:326)
> > > > > > at
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> org.apache.lens.client.LensMetadataClient.addPartitionToFactTable(LensMetadataClient.java:842)
> > > > > > at
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> org.apache.lens.examples.PopulateSampleMetastore.createFactPartition(PopulateSampleMetastore.java:123)
> > > > > > at
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> org.apache.lens.examples.PopulateSampleMetastore.populateFactTables(PopulateSampleMetastore.java:133)
> > > > > > at
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> org.apache.lens.examples.PopulateSampleMetastore.populateAll(PopulateSampleMetastore.java:66)
> > > > > > at
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> org.apache.lens.examples.PopulateSampleMetastore.main(PopulateSampleMetastore.java:55)
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
> ------------------------------------------------------------------------------------
> > > > > > yash@yash client $./bin/run-examples.sh sample-metastore
> > > > > > Creating storage from:local-storage.xml failed,
> > > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException:
> Exception
> > > > > creating
> > > > > > table
> > > > > > Creating storage from:local-cluster-storage.xml failed,
> > > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException:
> Exception
> > > > > creating
> > > > > > table
> > > > > > Creating storage from:db-storage.xml failed,
> > > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException:
> Exception
> > > > > creating
> > > > > > table
> > > > > > Creating cube from:sample-cube.xml failed,
> > > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException:
> Exception
> > > > > creating
> > > > > > table
> > > > > > Creating dimension from:sample-dimension.xml failed,
> > > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException:
> Exception
> > > > > creating
> > > > > > table
> > > > > > Creating dimension from:sample-dimension2.xml failed,
> > > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException:
> Exception
> > > > > creating
> > > > > > table
> > > > > > Creating dimension from:sample-db-only-dimension.xml failed,
> > > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException:
> Exception
> > > > > creating
> > > > > > table
> > > > > > Creating fact table from: fact1.xml failed,
> > > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException:
> Exception
> > > > > creating
> > > > > > table
> > > > > > Creating fact table from: fact2.xml failed,
> > > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException:
> Exception
> > > > > creating
> > > > > > table
> > > > > > Creating fact table from: rawfact.xml failed,
> > > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException:
> Exception
> > > > > creating
> > > > > > table
> > > > > > Creating dim table from: dim_table.xml failed,
> > > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException:
> Exception
> > > > > creating
> > > > > > table
> > > > > > Creating dim table from: dim_table2.xml failed,
> > > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException:
> Exception
> > > > > creating
> > > > > > table
> > > > > > Creating dim table from: dim_table3.xmlfailed,
> > > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException:
> Exception
> > > > > creating
> > > > > > table
> > > > > > Creating dim table from: dim_table4.xml failed,
> > > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException:
> Exception
> > > > > creating
> > > > > > table
> > > > > > Created sample metastore!
> > > > > > Database:default
> > > > > > Storages:null
> > > > > > Cubes:null
> > > > > > Dimensions:null
> > > > > > Fact tables:null
> > > > > > Dimension tables:null
> > > > > >
> > > > > > ---------------------------------------------
> > > > > > LOGS: logs/lensclient.log
> > > > > > ---------------------------------------------
> > > > > > 28 Apr 2015 23:17:00,853 [main] INFO
> > > hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > > > -
> > > > > > Checkpoint start
> > > > > > 28 Apr 2015 23:17:00,854 [main] INFO
> > > hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > > > -
> > > > > > checkpointClose start
> > > > > > 28 Apr 2015 23:17:00,874 [main] INFO
> > > hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > > > -
> > > > > > checkpointClose end
> > > > > > 28 Apr 2015 23:17:00,879 [main] INFO
> > > hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > > > -
> > > > > > Checkpoint end
> > > > > > 28 Apr 2015 23:17:00,913 [main] INFO
> > > hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > > > -
> > > > > > Database closed
> > > > > > 28 Apr 2015 23:17:34,125 [main] INFO
> > > hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > > > -
> > > > > > Database closed
> > > > > >
> > > > >
> > > >
> > >
> >
>
Re: Error while trying examples script on lens
Posted by Yash Sharma <ya...@gmail.com>.
Thanks Rajat and Amreshwari -
I was able to run the example scripts by changing permissions for
/user/hive/warehouse.
Amreshwari - I would like to start on LENS-527. I wonder if we need to add
the changes for both conf & conf-pseudo-distr ?
Regards
Files:
tools/conf-pseudo-distr/server/lens-site.xml
tools/conf/server/lens-site.xml
On Wed, Apr 29, 2015 at 9:52 AM, amareshwarisr . <am...@gmail.com>
wrote:
> Created https://issues.apache.org/jira/browse/LENS-527 for the issue. On
> mac machines, usually we did not face the issue - so it was not seen.
>
> The configuration should go in lens-site.xml than hive-site.xml, as we do
> not have hive-site.xml in server conf directory.
>
> Yash, feel free to pick it up and put changes required, if you can. This
> would good one to start contributing.
>
> Thanks
> Amareshwari
>
> On Wed, Apr 29, 2015 at 1:04 AM, Rajat Khandelwal <ra...@gmail.com>
> wrote:
>
> > You have to change hive warehouse directory in server conf hive-site.xml
> >
> > It's right now inside /usr/hive/warehouse where you don't have
> permissions
> > right now.
> >
> > On Wed, Apr 29, 2015, 00:45 Yash Sharma <ya...@gmail.com> wrote:
> >
> > > Thanks Rajat,
> > > I see the same errors when swapping the order of commands.
> > > I can help you with the server logs though.
> > >
> > > https://gist.github.com/yssharma/8a5e367e73654e3b6ce9
> > >
> > > Regards
> > >
> > > On Wed, Apr 29, 2015 at 12:33 AM, Rajat Khandelwal <
> > rajatgupta59@gmail.com
> > > >
> > > wrote:
> > >
> > > > Just to confirm, you have to do sample-metastore before and
> > > > populate-metastore after.
> > > >
> > > > Given that, server logs would be more helpful for debugging.
> > > >
> > > > Just posting a quick reply before I try to reproduce the issue.
> > > >
> > > > On Tue, Apr 28, 2015 at 11:57 PM Yash Sharma <ya...@gmail.com>
> > wrote:
> > > >
> > > > > Hi All,
> > > > > I am stumbling upon this error while trying out the examples on
> > Lens. I
> > > > > might be missing out something trivial - Hope if I can get any tips
> > > here.
> > > > >
> > > > > Env Details:
> > > > > (Ubuntu 14.04.2 LTS, Apache Maven 3.2.5, Java version: 1.7.0_75)
> > > > >
> > > > > Thanks
> > > > >
> > > > > Adding the error messages and Logs below:
> > > > >
> > > > > --------------------------------------------------------------
> > > > > yash@yash client $./bin/run-examples.sh populate-metastore
> > > > > Adding partition from:dim1-local-part.xml failed
> > > > > Adding partition from:dim2-local-part.xml failed
> > > > > Adding partition from:dim4-local-part.xml failed
> > > > > Created DB storages for dim_table3 and dim_table4
> > > > > Exception in thread "main" javax.ws.rs.NotFoundException: HTTP 404
> > Not
> > > > > Found
> > > > > at
> > > > >
> > > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation.convertToException(JerseyInvocation.java:913)
> > > > > at
> > > > >
> > > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation.translate(JerseyInvocation.java:770)
> > > > > at
> > > > >
> > > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation.access$500(JerseyInvocation.java:90)
> > > > > at
> > > > >
> > > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation$2.call(JerseyInvocation.java:671)
> > > > > at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
> > > > > at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
> > > > > at org.glassfish.jersey.internal.Errors.process(Errors.java:228)
> > > > > at
> > > > >
> > > > >
> > > >
> > >
> >
> org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:422)
> > > > > at
> > > > >
> > > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:667)
> > > > > at
> > > > >
> > > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:423)
> > > > > at
> > > > >
> > > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation$Builder.post(JerseyInvocation.java:326)
> > > > > at
> > > > >
> > > > >
> > > >
> > >
> >
> org.apache.lens.client.LensMetadataClient.addPartitionToFactTable(LensMetadataClient.java:842)
> > > > > at
> > > > >
> > > > >
> > > >
> > >
> >
> org.apache.lens.examples.PopulateSampleMetastore.createFactPartition(PopulateSampleMetastore.java:123)
> > > > > at
> > > > >
> > > > >
> > > >
> > >
> >
> org.apache.lens.examples.PopulateSampleMetastore.populateFactTables(PopulateSampleMetastore.java:133)
> > > > > at
> > > > >
> > > > >
> > > >
> > >
> >
> org.apache.lens.examples.PopulateSampleMetastore.populateAll(PopulateSampleMetastore.java:66)
> > > > > at
> > > > >
> > > > >
> > > >
> > >
> >
> org.apache.lens.examples.PopulateSampleMetastore.main(PopulateSampleMetastore.java:55)
> > > > >
> > > > >
> > > > >
> > > >
> > >
> >
> ------------------------------------------------------------------------------------
> > > > > yash@yash client $./bin/run-examples.sh sample-metastore
> > > > > Creating storage from:local-storage.xml failed,
> > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > > creating
> > > > > table
> > > > > Creating storage from:local-cluster-storage.xml failed,
> > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > > creating
> > > > > table
> > > > > Creating storage from:db-storage.xml failed,
> > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > > creating
> > > > > table
> > > > > Creating cube from:sample-cube.xml failed,
> > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > > creating
> > > > > table
> > > > > Creating dimension from:sample-dimension.xml failed,
> > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > > creating
> > > > > table
> > > > > Creating dimension from:sample-dimension2.xml failed,
> > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > > creating
> > > > > table
> > > > > Creating dimension from:sample-db-only-dimension.xml failed,
> > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > > creating
> > > > > table
> > > > > Creating fact table from: fact1.xml failed,
> > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > > creating
> > > > > table
> > > > > Creating fact table from: fact2.xml failed,
> > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > > creating
> > > > > table
> > > > > Creating fact table from: rawfact.xml failed,
> > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > > creating
> > > > > table
> > > > > Creating dim table from: dim_table.xml failed,
> > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > > creating
> > > > > table
> > > > > Creating dim table from: dim_table2.xml failed,
> > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > > creating
> > > > > table
> > > > > Creating dim table from: dim_table3.xmlfailed,
> > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > > creating
> > > > > table
> > > > > Creating dim table from: dim_table4.xml failed,
> > > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > > creating
> > > > > table
> > > > > Created sample metastore!
> > > > > Database:default
> > > > > Storages:null
> > > > > Cubes:null
> > > > > Dimensions:null
> > > > > Fact tables:null
> > > > > Dimension tables:null
> > > > >
> > > > > ---------------------------------------------
> > > > > LOGS: logs/lensclient.log
> > > > > ---------------------------------------------
> > > > > 28 Apr 2015 23:17:00,853 [main] INFO
> > hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > > -
> > > > > Checkpoint start
> > > > > 28 Apr 2015 23:17:00,854 [main] INFO
> > hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > > -
> > > > > checkpointClose start
> > > > > 28 Apr 2015 23:17:00,874 [main] INFO
> > hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > > -
> > > > > checkpointClose end
> > > > > 28 Apr 2015 23:17:00,879 [main] INFO
> > hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > > -
> > > > > Checkpoint end
> > > > > 28 Apr 2015 23:17:00,913 [main] INFO
> > hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > > -
> > > > > Database closed
> > > > > 28 Apr 2015 23:17:34,125 [main] INFO
> > hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > > -
> > > > > Database closed
> > > > >
> > > >
> > >
> >
>
Re: Error while trying examples script on lens
Posted by "amareshwarisr ." <am...@gmail.com>.
Created https://issues.apache.org/jira/browse/LENS-527 for the issue. On
mac machines, usually we did not face the issue - so it was not seen.
The configuration should go in lens-site.xml than hive-site.xml, as we do
not have hive-site.xml in server conf directory.
Yash, feel free to pick it up and put changes required, if you can. This
would good one to start contributing.
Thanks
Amareshwari
On Wed, Apr 29, 2015 at 1:04 AM, Rajat Khandelwal <ra...@gmail.com>
wrote:
> You have to change hive warehouse directory in server conf hive-site.xml
>
> It's right now inside /usr/hive/warehouse where you don't have permissions
> right now.
>
> On Wed, Apr 29, 2015, 00:45 Yash Sharma <ya...@gmail.com> wrote:
>
> > Thanks Rajat,
> > I see the same errors when swapping the order of commands.
> > I can help you with the server logs though.
> >
> > https://gist.github.com/yssharma/8a5e367e73654e3b6ce9
> >
> > Regards
> >
> > On Wed, Apr 29, 2015 at 12:33 AM, Rajat Khandelwal <
> rajatgupta59@gmail.com
> > >
> > wrote:
> >
> > > Just to confirm, you have to do sample-metastore before and
> > > populate-metastore after.
> > >
> > > Given that, server logs would be more helpful for debugging.
> > >
> > > Just posting a quick reply before I try to reproduce the issue.
> > >
> > > On Tue, Apr 28, 2015 at 11:57 PM Yash Sharma <ya...@gmail.com>
> wrote:
> > >
> > > > Hi All,
> > > > I am stumbling upon this error while trying out the examples on
> Lens. I
> > > > might be missing out something trivial - Hope if I can get any tips
> > here.
> > > >
> > > > Env Details:
> > > > (Ubuntu 14.04.2 LTS, Apache Maven 3.2.5, Java version: 1.7.0_75)
> > > >
> > > > Thanks
> > > >
> > > > Adding the error messages and Logs below:
> > > >
> > > > --------------------------------------------------------------
> > > > yash@yash client $./bin/run-examples.sh populate-metastore
> > > > Adding partition from:dim1-local-part.xml failed
> > > > Adding partition from:dim2-local-part.xml failed
> > > > Adding partition from:dim4-local-part.xml failed
> > > > Created DB storages for dim_table3 and dim_table4
> > > > Exception in thread "main" javax.ws.rs.NotFoundException: HTTP 404
> Not
> > > > Found
> > > > at
> > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation.convertToException(JerseyInvocation.java:913)
> > > > at
> > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation.translate(JerseyInvocation.java:770)
> > > > at
> > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation.access$500(JerseyInvocation.java:90)
> > > > at
> > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation$2.call(JerseyInvocation.java:671)
> > > > at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
> > > > at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
> > > > at org.glassfish.jersey.internal.Errors.process(Errors.java:228)
> > > > at
> > > >
> > > >
> > >
> >
> org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:422)
> > > > at
> > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:667)
> > > > at
> > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:423)
> > > > at
> > > >
> > > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation$Builder.post(JerseyInvocation.java:326)
> > > > at
> > > >
> > > >
> > >
> >
> org.apache.lens.client.LensMetadataClient.addPartitionToFactTable(LensMetadataClient.java:842)
> > > > at
> > > >
> > > >
> > >
> >
> org.apache.lens.examples.PopulateSampleMetastore.createFactPartition(PopulateSampleMetastore.java:123)
> > > > at
> > > >
> > > >
> > >
> >
> org.apache.lens.examples.PopulateSampleMetastore.populateFactTables(PopulateSampleMetastore.java:133)
> > > > at
> > > >
> > > >
> > >
> >
> org.apache.lens.examples.PopulateSampleMetastore.populateAll(PopulateSampleMetastore.java:66)
> > > > at
> > > >
> > > >
> > >
> >
> org.apache.lens.examples.PopulateSampleMetastore.main(PopulateSampleMetastore.java:55)
> > > >
> > > >
> > > >
> > >
> >
> ------------------------------------------------------------------------------------
> > > > yash@yash client $./bin/run-examples.sh sample-metastore
> > > > Creating storage from:local-storage.xml failed,
> > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > creating
> > > > table
> > > > Creating storage from:local-cluster-storage.xml failed,
> > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > creating
> > > > table
> > > > Creating storage from:db-storage.xml failed,
> > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > creating
> > > > table
> > > > Creating cube from:sample-cube.xml failed,
> > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > creating
> > > > table
> > > > Creating dimension from:sample-dimension.xml failed,
> > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > creating
> > > > table
> > > > Creating dimension from:sample-dimension2.xml failed,
> > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > creating
> > > > table
> > > > Creating dimension from:sample-db-only-dimension.xml failed,
> > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > creating
> > > > table
> > > > Creating fact table from: fact1.xml failed,
> > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > creating
> > > > table
> > > > Creating fact table from: fact2.xml failed,
> > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > creating
> > > > table
> > > > Creating fact table from: rawfact.xml failed,
> > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > creating
> > > > table
> > > > Creating dim table from: dim_table.xml failed,
> > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > creating
> > > > table
> > > > Creating dim table from: dim_table2.xml failed,
> > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > creating
> > > > table
> > > > Creating dim table from: dim_table3.xmlfailed,
> > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > creating
> > > > table
> > > > Creating dim table from: dim_table4.xml failed,
> > > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > > creating
> > > > table
> > > > Created sample metastore!
> > > > Database:default
> > > > Storages:null
> > > > Cubes:null
> > > > Dimensions:null
> > > > Fact tables:null
> > > > Dimension tables:null
> > > >
> > > > ---------------------------------------------
> > > > LOGS: logs/lensclient.log
> > > > ---------------------------------------------
> > > > 28 Apr 2015 23:17:00,853 [main] INFO
> hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > -
> > > > Checkpoint start
> > > > 28 Apr 2015 23:17:00,854 [main] INFO
> hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > -
> > > > checkpointClose start
> > > > 28 Apr 2015 23:17:00,874 [main] INFO
> hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > -
> > > > checkpointClose end
> > > > 28 Apr 2015 23:17:00,879 [main] INFO
> hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > -
> > > > Checkpoint end
> > > > 28 Apr 2015 23:17:00,913 [main] INFO
> hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > -
> > > > Database closed
> > > > 28 Apr 2015 23:17:34,125 [main] INFO
> hsqldb.db.HSQLDB4D01239D53.ENGINE
> > > -
> > > > Database closed
> > > >
> > >
> >
>
Re: Error while trying examples script on lens
Posted by Rajat Khandelwal <ra...@gmail.com>.
You have to change hive warehouse directory in server conf hive-site.xml
It's right now inside /usr/hive/warehouse where you don't have permissions
right now.
On Wed, Apr 29, 2015, 00:45 Yash Sharma <ya...@gmail.com> wrote:
> Thanks Rajat,
> I see the same errors when swapping the order of commands.
> I can help you with the server logs though.
>
> https://gist.github.com/yssharma/8a5e367e73654e3b6ce9
>
> Regards
>
> On Wed, Apr 29, 2015 at 12:33 AM, Rajat Khandelwal <rajatgupta59@gmail.com
> >
> wrote:
>
> > Just to confirm, you have to do sample-metastore before and
> > populate-metastore after.
> >
> > Given that, server logs would be more helpful for debugging.
> >
> > Just posting a quick reply before I try to reproduce the issue.
> >
> > On Tue, Apr 28, 2015 at 11:57 PM Yash Sharma <ya...@gmail.com> wrote:
> >
> > > Hi All,
> > > I am stumbling upon this error while trying out the examples on Lens. I
> > > might be missing out something trivial - Hope if I can get any tips
> here.
> > >
> > > Env Details:
> > > (Ubuntu 14.04.2 LTS, Apache Maven 3.2.5, Java version: 1.7.0_75)
> > >
> > > Thanks
> > >
> > > Adding the error messages and Logs below:
> > >
> > > --------------------------------------------------------------
> > > yash@yash client $./bin/run-examples.sh populate-metastore
> > > Adding partition from:dim1-local-part.xml failed
> > > Adding partition from:dim2-local-part.xml failed
> > > Adding partition from:dim4-local-part.xml failed
> > > Created DB storages for dim_table3 and dim_table4
> > > Exception in thread "main" javax.ws.rs.NotFoundException: HTTP 404 Not
> > > Found
> > > at
> > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation.convertToException(JerseyInvocation.java:913)
> > > at
> > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation.translate(JerseyInvocation.java:770)
> > > at
> > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation.access$500(JerseyInvocation.java:90)
> > > at
> > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation$2.call(JerseyInvocation.java:671)
> > > at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
> > > at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
> > > at org.glassfish.jersey.internal.Errors.process(Errors.java:228)
> > > at
> > >
> > >
> >
> org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:422)
> > > at
> > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:667)
> > > at
> > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:423)
> > > at
> > >
> > >
> >
> org.glassfish.jersey.client.JerseyInvocation$Builder.post(JerseyInvocation.java:326)
> > > at
> > >
> > >
> >
> org.apache.lens.client.LensMetadataClient.addPartitionToFactTable(LensMetadataClient.java:842)
> > > at
> > >
> > >
> >
> org.apache.lens.examples.PopulateSampleMetastore.createFactPartition(PopulateSampleMetastore.java:123)
> > > at
> > >
> > >
> >
> org.apache.lens.examples.PopulateSampleMetastore.populateFactTables(PopulateSampleMetastore.java:133)
> > > at
> > >
> > >
> >
> org.apache.lens.examples.PopulateSampleMetastore.populateAll(PopulateSampleMetastore.java:66)
> > > at
> > >
> > >
> >
> org.apache.lens.examples.PopulateSampleMetastore.main(PopulateSampleMetastore.java:55)
> > >
> > >
> > >
> >
> ------------------------------------------------------------------------------------
> > > yash@yash client $./bin/run-examples.sh sample-metastore
> > > Creating storage from:local-storage.xml failed,
> > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > creating
> > > table
> > > Creating storage from:local-cluster-storage.xml failed,
> > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > creating
> > > table
> > > Creating storage from:db-storage.xml failed,
> > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > creating
> > > table
> > > Creating cube from:sample-cube.xml failed,
> > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > creating
> > > table
> > > Creating dimension from:sample-dimension.xml failed,
> > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > creating
> > > table
> > > Creating dimension from:sample-dimension2.xml failed,
> > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > creating
> > > table
> > > Creating dimension from:sample-db-only-dimension.xml failed,
> > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > creating
> > > table
> > > Creating fact table from: fact1.xml failed,
> > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > creating
> > > table
> > > Creating fact table from: fact2.xml failed,
> > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > creating
> > > table
> > > Creating fact table from: rawfact.xml failed,
> > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > creating
> > > table
> > > Creating dim table from: dim_table.xml failed,
> > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > creating
> > > table
> > > Creating dim table from: dim_table2.xml failed,
> > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > creating
> > > table
> > > Creating dim table from: dim_table3.xmlfailed,
> > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > creating
> > > table
> > > Creating dim table from: dim_table4.xml failed,
> > > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> > creating
> > > table
> > > Created sample metastore!
> > > Database:default
> > > Storages:null
> > > Cubes:null
> > > Dimensions:null
> > > Fact tables:null
> > > Dimension tables:null
> > >
> > > ---------------------------------------------
> > > LOGS: logs/lensclient.log
> > > ---------------------------------------------
> > > 28 Apr 2015 23:17:00,853 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE
> > -
> > > Checkpoint start
> > > 28 Apr 2015 23:17:00,854 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE
> > -
> > > checkpointClose start
> > > 28 Apr 2015 23:17:00,874 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE
> > -
> > > checkpointClose end
> > > 28 Apr 2015 23:17:00,879 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE
> > -
> > > Checkpoint end
> > > 28 Apr 2015 23:17:00,913 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE
> > -
> > > Database closed
> > > 28 Apr 2015 23:17:34,125 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE
> > -
> > > Database closed
> > >
> >
>
Re: Error while trying examples script on lens
Posted by Yash Sharma <ya...@gmail.com>.
Thanks Rajat,
I see the same errors when swapping the order of commands.
I can help you with the server logs though.
https://gist.github.com/yssharma/8a5e367e73654e3b6ce9
Regards
On Wed, Apr 29, 2015 at 12:33 AM, Rajat Khandelwal <ra...@gmail.com>
wrote:
> Just to confirm, you have to do sample-metastore before and
> populate-metastore after.
>
> Given that, server logs would be more helpful for debugging.
>
> Just posting a quick reply before I try to reproduce the issue.
>
> On Tue, Apr 28, 2015 at 11:57 PM Yash Sharma <ya...@gmail.com> wrote:
>
> > Hi All,
> > I am stumbling upon this error while trying out the examples on Lens. I
> > might be missing out something trivial - Hope if I can get any tips here.
> >
> > Env Details:
> > (Ubuntu 14.04.2 LTS, Apache Maven 3.2.5, Java version: 1.7.0_75)
> >
> > Thanks
> >
> > Adding the error messages and Logs below:
> >
> > --------------------------------------------------------------
> > yash@yash client $./bin/run-examples.sh populate-metastore
> > Adding partition from:dim1-local-part.xml failed
> > Adding partition from:dim2-local-part.xml failed
> > Adding partition from:dim4-local-part.xml failed
> > Created DB storages for dim_table3 and dim_table4
> > Exception in thread "main" javax.ws.rs.NotFoundException: HTTP 404 Not
> > Found
> > at
> >
> >
> org.glassfish.jersey.client.JerseyInvocation.convertToException(JerseyInvocation.java:913)
> > at
> >
> >
> org.glassfish.jersey.client.JerseyInvocation.translate(JerseyInvocation.java:770)
> > at
> >
> >
> org.glassfish.jersey.client.JerseyInvocation.access$500(JerseyInvocation.java:90)
> > at
> >
> >
> org.glassfish.jersey.client.JerseyInvocation$2.call(JerseyInvocation.java:671)
> > at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
> > at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
> > at org.glassfish.jersey.internal.Errors.process(Errors.java:228)
> > at
> >
> >
> org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:422)
> > at
> >
> >
> org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:667)
> > at
> >
> >
> org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:423)
> > at
> >
> >
> org.glassfish.jersey.client.JerseyInvocation$Builder.post(JerseyInvocation.java:326)
> > at
> >
> >
> org.apache.lens.client.LensMetadataClient.addPartitionToFactTable(LensMetadataClient.java:842)
> > at
> >
> >
> org.apache.lens.examples.PopulateSampleMetastore.createFactPartition(PopulateSampleMetastore.java:123)
> > at
> >
> >
> org.apache.lens.examples.PopulateSampleMetastore.populateFactTables(PopulateSampleMetastore.java:133)
> > at
> >
> >
> org.apache.lens.examples.PopulateSampleMetastore.populateAll(PopulateSampleMetastore.java:66)
> > at
> >
> >
> org.apache.lens.examples.PopulateSampleMetastore.main(PopulateSampleMetastore.java:55)
> >
> >
> >
> ------------------------------------------------------------------------------------
> > yash@yash client $./bin/run-examples.sh sample-metastore
> > Creating storage from:local-storage.xml failed,
> > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> creating
> > table
> > Creating storage from:local-cluster-storage.xml failed,
> > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> creating
> > table
> > Creating storage from:db-storage.xml failed,
> > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> creating
> > table
> > Creating cube from:sample-cube.xml failed,
> > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> creating
> > table
> > Creating dimension from:sample-dimension.xml failed,
> > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> creating
> > table
> > Creating dimension from:sample-dimension2.xml failed,
> > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> creating
> > table
> > Creating dimension from:sample-db-only-dimension.xml failed,
> > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> creating
> > table
> > Creating fact table from: fact1.xml failed,
> > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> creating
> > table
> > Creating fact table from: fact2.xml failed,
> > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> creating
> > table
> > Creating fact table from: rawfact.xml failed,
> > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> creating
> > table
> > Creating dim table from: dim_table.xml failed,
> > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> creating
> > table
> > Creating dim table from: dim_table2.xml failed,
> > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> creating
> > table
> > Creating dim table from: dim_table3.xmlfailed,
> > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> creating
> > table
> > Creating dim table from: dim_table4.xml failed,
> > reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception
> creating
> > table
> > Created sample metastore!
> > Database:default
> > Storages:null
> > Cubes:null
> > Dimensions:null
> > Fact tables:null
> > Dimension tables:null
> >
> > ---------------------------------------------
> > LOGS: logs/lensclient.log
> > ---------------------------------------------
> > 28 Apr 2015 23:17:00,853 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE
> -
> > Checkpoint start
> > 28 Apr 2015 23:17:00,854 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE
> -
> > checkpointClose start
> > 28 Apr 2015 23:17:00,874 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE
> -
> > checkpointClose end
> > 28 Apr 2015 23:17:00,879 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE
> -
> > Checkpoint end
> > 28 Apr 2015 23:17:00,913 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE
> -
> > Database closed
> > 28 Apr 2015 23:17:34,125 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE
> -
> > Database closed
> >
>
Re: Error while trying examples script on lens
Posted by Rajat Khandelwal <ra...@gmail.com>.
Just to confirm, you have to do sample-metastore before and
populate-metastore after.
Given that, server logs would be more helpful for debugging.
Just posting a quick reply before I try to reproduce the issue.
On Tue, Apr 28, 2015 at 11:57 PM Yash Sharma <ya...@gmail.com> wrote:
> Hi All,
> I am stumbling upon this error while trying out the examples on Lens. I
> might be missing out something trivial - Hope if I can get any tips here.
>
> Env Details:
> (Ubuntu 14.04.2 LTS, Apache Maven 3.2.5, Java version: 1.7.0_75)
>
> Thanks
>
> Adding the error messages and Logs below:
>
> --------------------------------------------------------------
> yash@yash client $./bin/run-examples.sh populate-metastore
> Adding partition from:dim1-local-part.xml failed
> Adding partition from:dim2-local-part.xml failed
> Adding partition from:dim4-local-part.xml failed
> Created DB storages for dim_table3 and dim_table4
> Exception in thread "main" javax.ws.rs.NotFoundException: HTTP 404 Not
> Found
> at
>
> org.glassfish.jersey.client.JerseyInvocation.convertToException(JerseyInvocation.java:913)
> at
>
> org.glassfish.jersey.client.JerseyInvocation.translate(JerseyInvocation.java:770)
> at
>
> org.glassfish.jersey.client.JerseyInvocation.access$500(JerseyInvocation.java:90)
> at
>
> org.glassfish.jersey.client.JerseyInvocation$2.call(JerseyInvocation.java:671)
> at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
> at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
> at org.glassfish.jersey.internal.Errors.process(Errors.java:228)
> at
>
> org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:422)
> at
>
> org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:667)
> at
>
> org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:423)
> at
>
> org.glassfish.jersey.client.JerseyInvocation$Builder.post(JerseyInvocation.java:326)
> at
>
> org.apache.lens.client.LensMetadataClient.addPartitionToFactTable(LensMetadataClient.java:842)
> at
>
> org.apache.lens.examples.PopulateSampleMetastore.createFactPartition(PopulateSampleMetastore.java:123)
> at
>
> org.apache.lens.examples.PopulateSampleMetastore.populateFactTables(PopulateSampleMetastore.java:133)
> at
>
> org.apache.lens.examples.PopulateSampleMetastore.populateAll(PopulateSampleMetastore.java:66)
> at
>
> org.apache.lens.examples.PopulateSampleMetastore.main(PopulateSampleMetastore.java:55)
>
>
> ------------------------------------------------------------------------------------
> yash@yash client $./bin/run-examples.sh sample-metastore
> Creating storage from:local-storage.xml failed,
> reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
> table
> Creating storage from:local-cluster-storage.xml failed,
> reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
> table
> Creating storage from:db-storage.xml failed,
> reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
> table
> Creating cube from:sample-cube.xml failed,
> reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
> table
> Creating dimension from:sample-dimension.xml failed,
> reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
> table
> Creating dimension from:sample-dimension2.xml failed,
> reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
> table
> Creating dimension from:sample-db-only-dimension.xml failed,
> reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
> table
> Creating fact table from: fact1.xml failed,
> reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
> table
> Creating fact table from: fact2.xml failed,
> reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
> table
> Creating fact table from: rawfact.xml failed,
> reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
> table
> Creating dim table from: dim_table.xml failed,
> reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
> table
> Creating dim table from: dim_table2.xml failed,
> reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
> table
> Creating dim table from: dim_table3.xmlfailed,
> reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
> table
> Creating dim table from: dim_table4.xml failed,
> reason:org.apache.hadoop.hive.ql.metadata.HiveException: Exception creating
> table
> Created sample metastore!
> Database:default
> Storages:null
> Cubes:null
> Dimensions:null
> Fact tables:null
> Dimension tables:null
>
> ---------------------------------------------
> LOGS: logs/lensclient.log
> ---------------------------------------------
> 28 Apr 2015 23:17:00,853 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE -
> Checkpoint start
> 28 Apr 2015 23:17:00,854 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE -
> checkpointClose start
> 28 Apr 2015 23:17:00,874 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE -
> checkpointClose end
> 28 Apr 2015 23:17:00,879 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE -
> Checkpoint end
> 28 Apr 2015 23:17:00,913 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE -
> Database closed
> 28 Apr 2015 23:17:34,125 [main] INFO hsqldb.db.HSQLDB4D01239D53.ENGINE -
> Database closed
>