Hi Team,
Gentle reminder!
Regards,
Neha Saini
From: Neha Saini
Sent: Thursday, October 10, 2019 3:30 PM
To: dev@calcite.apache.org
Subject: Calcite - Model - MongoDB view
Hi Team,
Greetings for the day.
I am working as a technical architect in HCL technologies.
I am doing a PoC on Apache calcite.
Using MongoDB adapter I want to use calcite sql parser on mongo db database.
I am stuck at a point and need your help in the same.
My data in Mongo DB has following structure:-
{
"_id": "tt0772249",
"title": "Palaces of a Queen",
"type": "movie",
"year": 1967,
"crew": [{
"name": "Micael
Calunga",
"role": "actor"
}, {
"name": "Jordon
Zonotti",
"role":
"actress"
}
]
}
I want to create view with column title, year, crew.name
But in modql.json , I am not able to MAP array of objects, like crew.name 0th
element, or nth element.
"tables": [
{
"name": "movie",
"type": "view",
"sql": "select cast(_MAP['title'] AS varchar(100)) AS title,
cast(_MAP['year'] AS varchar(4)) AS year, cast(_MAP['crew.name'][0] AS
varchar(20)) AS crewname from \"mongo_raw\".\"movie\""
},
In the GIThib code, we have zip example, but zip file is a flat json, but json
I am using is embedded , hence not able to use the example.
I would really appreciate some help.
Thanks!
Regards,
Neha Saini
::DISCLAIMER::
________________________________
The contents of this e-mail and any attachment(s) are confidential and intended
for the named recipient(s) only. E-mail transmission is not guaranteed to be
secure or error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or may contain viruses in transmission.
The e mail and its contents (with or without referred errors) shall therefore
not attach any liability on the originator or HCL or its affiliates. Views or
opinions, if any, presented in this email are solely those of the author and
may not necessarily reflect the views or opinions of HCL or its affiliates. Any
form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written
consent of authorized representative of HCL is strictly prohibited. If you have
received this email in error please delete it and notify the sender
immediately. Before opening any email and/or attachments, please check them for
viruses and other defects.
________________________________
