Hi all,I have couple of questions to ask as below:
1)
I have seen the Operator Type “IN”, “LIKE” etc. Is
there any plan for the following operators?
NOT IN
NOT LIKE
START WITH
NOT START WITH
2)
Schema discovery. I am able to discover the
tables and their columns by given database (schema) name). Is there a way to
discover all the databases contains by the given connection(data context)?
3)
For MongoDB, XML or json file connector, how do
I query, filter or perform aggregation from sub document.
Example:
{ "product": "Product ABC",
"Model": "Model ABC",
"Transaction": { [
{"Date": "ISO Date",
"Amount": 10000.00},
{"Date": "ISO Date",
"Amount": 1200.00},
]}
}
Is there a way to return the flatten table, and how
do I write a query to filter by date, and to obtain the total amount?
4)
Is there a plan to support Impala and Hive
connector?
Thank you.regardspacketeer
