lingual jdbc connection string

[neil....@wherescape.com]

I am new to Lingual and working through the tutorials.   I have Hadoop 2.5.1 cluster running and lingual installed.  Employees.tar file contents is uploaded to the hdfs environment (/user/neil/...)    From lingual shell I can create the necessary tables and execute the sql as per the user guide.  working.unique_titles tables was created fine and has the 7 rows loaded.

I am now trying to follow the JdbcExample to run a java class that will connect via JDBC and execute a query against the working.unique_titles table.  I seem to be having issues with the DriverManager Connection string definition.  I am sure it is something simple that I am missing, but all examples I can find reference using "local" platform.  Regardless of what changes I make to the connection definition, I receive errors -- "unable to get handle to get filesystem for: hdfs", or 

Connection connection = DriverManager.getConnection("jdbc:lingual:hadoop2-mr1;catalog=hdfs://Osiris-2.local:9000/user/neil/.lingual/catalog;user=neil;schema=working");

Assuming my lingual environment is running on Hadoop 2.5.1 cluster.  My user account is neil and the catalog location is hdfs://Osiris-2.local:9000/user/neil/.lingual/catalog.

Are their examples laying around that show how this connection string should look?  Hopefully this is something simple I have forgotten to configure, but I have been unable to find the magic set of properties to get it to work.

Thanks.

[Andre Kelpe]

Hi Neil,

sorry for the late reply. I am not able to reproduce your exact error in my setup, however I found another problem, which needs to be fixed. I will get back to you here, once we have a new build.

Again, sorry for the late reply.

- André

--
You received this message because you are subscribed to the Google Groups "Lingual User" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lingual-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

André Kelpe
an...@concurrentinc.com
http://concurrentinc.com

[Andre Kelpe]

Hi again,

so the first problem for your configuration is that you gave the full path to the catalog. Lingual only wants the base-dir. (this should be more robust and we should fail more gracefully...) That means either: jdbc:lingual:hadoop2-mr1;catalog=hdfs://Osiris-2.local:9000/user/neil/;schema=working" or even shorter jdbc:lingual:hadoop2-mr1;catalog=/user/neil/;schema=working" should work. I found out that there are method signature mismatches in the guava versions we use and the one that ships with hadoop 2.5.2, so I had to update the code in a few parts to be able to use the lingual-examples project with hadoop2-mr1. If you fetch the wip-1.2 branch from here https://github.com/Cascading/lingual/tree/wip-1.2 you should get the thing to run.

If you run into any other problem, please let us know.

- André

On Tue, Dec 30, 2014 at 2:21 AM, <neil....@wherescape.com> wrote:

--
You received this message because you are subscribed to the Google Groups "Lingual User" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lingual-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.