[teiid-issues] [JBoss JIRA] (TEIID-4928) Couchbase - NAMEINSOURCE required for all the columns and tables

[Kylin Soong (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13411683#comment-13411683 ] 

Kylin Soong edited comment on TEIID-4928 at 5/25/17 6:05 AM:
-------------------------------------------------------------

> A you saying that we'll need more documentation on how to define the metadata manually?  Or are you suggesting that we should reuse the simba schema tools?
* reuse simba schema tools seems has difficult, I prefer to add more documents, probably we add a tools like the teiid-oauth-util.sh, run this tool can generate a ddl,sql or souce-model,xml. 
* I added a enhance in TEIID-4933, add another sampleKeyspaces property for limit the scope of keyspaces, if set a smaller scope of keyspaces(only set one or two), then the sampleSize can set a larger value, which can match some of Juraj's expects. TEIID-4933 also add support multiple typed name per keyspace, this can make the table map more fine-grained, in most of times, u the sers may focus on the documents in specific keyspace, supported multiple typed name can better match their requirements.
* I also add more content of documents, but it still not enough.


was (Author: kylin):
> A you saying that we'll need more documentation on how to define the metadata manually?  Or are you suggesting that we should reuse the simba schema tools?
simba schema tools seems has difficult, probably we add a tools like the teiid-oauth-util.sh, run this tool can generate a ddl,sql or souce-model,xml. How to define the metadata manually also is lacked.

> Couchbase - NAMEINSOURCE required for all the columns and tables
> ----------------------------------------------------------------
>
>                 Key: TEIID-4928
>                 URL: https://issues.jboss.org/browse/TEIID-4928
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 9.3
>            Reporter: Juraj Duráni
>            Assignee: Kylin Soong
>
> Option *NAMEINSOURCE* is de facto required for all the columns and tables. If it is not present then:
> # column name in source query is not enclosed in back quotes - e.g. *`$cb_t1`.ShortValue* instead of *`$cb_t1`.`ShortValue`*
> # name of the table is not added to the source query - e.g. *SELECT ... FROM null `$cb_t1` LET ... WHERE ...* instead of *SELECT ... FROM `smalla` `$cb_t1` LET ... WHERE ...*
> This should work OOB without need to add NAMEINSOURCE option. Teiid should automatically translate column name from e.g. *MyColumn* to *`MyColumn`* if option is not set. Same with name of the table.
> In case of table I think this is more serious as it does not even try name of the table but supplies *null* to the query



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)