Trying to add Derby DB as a Lens data source.

2016-09-07 Thread Pawan Malwal
ror : user lacks privilege or object not found: DIM_ACCOUNT lens-shell>show dimensions product sample_dim2 city sample_db_dim sample_dim customer Regards Pawan Malwal

Re: Trying to add Derby DB as a Lens data source.

2016-09-08 Thread Pawan Malwal
nsion table:* derbydb wrote: > Couple of things > > 1. You haven't created the dimension. You have to create manually. > 2. The JDBC Driver has to have derbystorage in its supported storages. > > > > On Wed, Sep 7, 2016 at 7:1

Re: Trying to add Derby DB as a Lens data source.

2016-09-09 Thread Pawan Malwal
n the CLASSPATH variable. Is this the correct way.? Regards Pawan Malwal On Fri, Sep 9, 2016 at 12:35 PM, Rajat Khandelwal wrote: > Apologies, I totally missed step 1. > > Can you try running a query on dimension? e.g. > > select account_name from account > > > > On Fr

Re: Trying to add Derby DB as a Lens data source.

2016-09-09 Thread Pawan Malwal
Got it. Thanks so much. Regards Pawan Malwal On Fri, Sep 9, 2016 at 12:57 PM, Rajat Khandelwal wrote: > Yes, exporting into LENSCPPATH is the way to do this. You can edit > lens-env.sh and add the export line there, or you can rely on bash sessions > to have that environment variabl

RE: Trying to add Derby DB as a Lens data source.

2016-09-12 Thread Pawan Malwal
rom com.mchange.v2.resourcepool.BasicResourcePool@5d754b10 -- timeout at awaitAvailable() Regards Pawan Malwal From: Pawan Malwal [mailto:pmalwal1...@gmail.com] Sent: 09 September 2016 13:03 To: user@lens.apache.org Cc: Sharanabasappa G Keriwaddi Subject: Re: Trying to add Derby DB as a Lens data source.

Supported MySQL version.

2016-09-15 Thread Pawan Malwal
enough or any other jar/s are also supposed to be added to Lesn to configure mysql jdbc driver.? Regards Pawan Malwal

NoCandidateDimAvailableException

2016-09-15 Thread Pawan Malwal
AILABLE[No candidate storages for any table] Regards Pawan Malwal

RE: NoCandidateDimAvailableException

2016-09-15 Thread Pawan Malwal
does not affect anything but I was wondering if there is any configuration issue due to which I am getting all these exceptions. lens.cube.query.driver.supported.storages mysql_storage true Regards Pawan Malwal From: Rajat Khandelwal [mailto:rajatgupt...@gmail.com] Sent: 15

RE: Supported MySQL version.

2016-09-15 Thread Pawan Malwal
:: lens.driver.jdbc.db.uri jdbc:mysql://HOST:PORT/dbname;user=;password== Correct Configuration:: lens.driver.jdbc.db.uri jdbc:mysql://HOST:PORT/dbname lens.driver.jdbc.db.user lens.driver.jdbc.db.password Regards Pawan Malwal From: Rajat

RE: NoCandidateDimAvailableException

2016-09-15 Thread Pawan Malwal
Thanks for the clarification Puneet. Yes, it’s pretty clear now. Regards Pawan Malwal From: Puneet Gupta [mailto:puneet.gu...@inmobi.com] Sent: 16 September 2016 11:31 To: user@lens.apache.org Cc: Sharanabasappa G Keriwaddi Subject: Re: NoCandidateDimAvailableException Hi Pawan When you

Cube creation failed.

2016-09-17 Thread Pawan Malwal
cube:0.1 cube-0.1.xsd "> lens-shell>create cube examples/resources/telecom/cdr-cube.xml failed Regards Pawan Malwal

RE: Cube creation failed.

2016-09-19 Thread Pawan Malwal
="uri:lens:cube:0.1 cube-0.1.xsd "> lens-shell>create cube examples/resources/telecom/temp.xml succeeded Thanks Pawan Malwal From: Puneet Gupta [mailto:puneet.gu...@inmobi.com] Sent: 19 September 2016 16:42 To: user@lens.apache.org C

RE: Cube creation failed.

2016-09-19 Thread Pawan Malwal
ot;uri:lens:cube:0.1":measures}' is expected. Regards Pawan Malwal From: Puneet Gupta [mailto:puneet.gu...@inmobi.com] Sent: 19 September 2016 16:42 To: user@lens.apache.org Cc: Sharanabasappa G Keriwaddi Subject: Re: Cube creation failed. Hi Pawan Looks like the error is on client sid

Tableau with Lens

2016-09-19 Thread Pawan Malwal
Hi Lens Developers, I am trying to use Tableau with Lens. Not sure how it should be configured.? Is there any plugin or something.? Could you please let me know how can this be done or direct me to any link or documentation. Regards Pawan Malwal

RE: [ANNOUNCE] New Apache Lens PMC member : Puneet Gupta

2016-09-20 Thread Pawan Malwal
Congratulations Puneet on your achievement..!! I must thank you and Lens team for all your support and help. Keep up the good work. Regards Pawan Malwal From: Amareshwari Sriramdasu [mailto:amareshw...@apache.org] Sent: 20 September 2016 09:59 To: dev ; user@lens.apache.org Subject: [ANNOUNCE

RE: Tableau with Lens

2016-09-20 Thread Pawan Malwal
driver implementation as its not tested throughly. Do give it a try. Making minor modifications should be easy. Code Path : lens-client/src/main/java/org/apache/lens/client/jdbc/ Thanks, Puneet Gupta On Mon, Sep 19, 2016 at 6:20 PM, Pawan Malwal mailto:pawan.mal...@huawei.com>> wrote: H

RE: Tableau with Lens

2016-09-21 Thread Pawan Malwal
Pawan Malwal From: amareshwarisr . [mailto:amareshw...@gmail.com] Sent: 21 September 2016 16:17 To: dev ; Piyush Mukati Cc: user@lens.apache.org; Sharanabasappa G Keriwaddi Subject: Re: Tableau with Lens AFAIK, JDBC client should automatically connect with correct url and configuration as

RE: Tableau with Lens

2016-09-23 Thread Pawan Malwal
Please let me know if you need more details on my configurations. Thank Pawan Malwal From: Puneet Gupta [mailto:puneet.gu...@inmobi.com] Sent: 23 September 2016 11:54 To: user@lens.apache.org; Deepak Barr Cc: dev ; Piyush Mukati ; Sharanabasappa G Keriwaddi Subject: Re: Tableau with Lens

Re: Tableau with Lens

2016-09-24 Thread Pawan Malwal
Thanks much Rajat, I will have a look at it and see if it helps. Hi Piyush, It would be great help if you can please share some details/updates on this.? Regards Pawan Malwal On Fri, Sep 23, 2016 at 3:28 PM, Rajat Khandelwal wrote: > Hi Pawan > > Piyush had proposed some chang