[
https://issues.jboss.org/browse/TEIID-4928?page=com.atlassian.jira.plugin...
]
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)