[ 
https://issues.apache.org/jira/browse/SOLR-9852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16413688#comment-16413688
 ] 

Saumitra Srivastav commented on SOLR-9852:
------------------------------------------

Whats the latest update on this? We are trying to use Solr as a datasource for 
Tableau through a jdbc-obdc bridge and its not able to fetch column metadata. 
If no one is working on this, I would like to try creating a patch for this. 
Looks like *getColumns* in 
https://github.com/apache/lucene-solr/blob/releases/lucene-solr/7.2.1/solr/solrj/src/java/org/apache/solr/client/solrj/io/sql/DatabaseMetaDataImpl.java#L739
 needs to be implemented. I am familiar with Solr, but not so much with jdbc. 
Can any solr dev provide a high level overview of what needs to be done here to 
help me get started.

> Solr JDBC doesn't implement columns' metadata
> ---------------------------------------------
>
>                 Key: SOLR-9852
>                 URL: https://issues.apache.org/jira/browse/SOLR-9852
>             Project: Solr
>          Issue Type: Bug
>      Security Level: Public(Default Security Level. Issues are Public) 
>          Components: Parallel SQL
>    Affects Versions: 6.3
>         Environment: N/A
>            Reporter: Rani Y.
>            Priority: Major
>              Labels: solrJ
>
> This is the error I get (from Squirrel SQL) while trying to get the objects 
> -meaning both tables and columns metadata
> 2016-12-12 13:47:48,241 [Thread-2] ERROR 
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo  - Error 
> occurred creating data types collection
> java.lang.UnsupportedOperationException
>       at 
> org.apache.solr.client.solrj.io.sql.DatabaseMetaDataImpl.getTypeInfo(DatabaseMetaDataImpl.java:773)
>       at 
> net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getDataTypesSimpleNames(SQLDatabaseMetaData.java:1978)
>       at 
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadDataTypes(SchemaInfo.java:900)
>       at 
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:315)
>       at 
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:208)
>       at 
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)
>       at 
> net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:315)
>       at 
> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
>       at java.lang.Thread.run(Thread.java:745)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to