[CALCITE-2371] how to perform joins in mongodb using model json in calcite

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Fix Version/s: 1.20.0
• Assignee: Unassigned
• Reporter: Subbarao
• Created: 20/Jun/18 09:48
• Updated: 24/Jun/19 21:51
• Resolved: 17/May/19 20:22

Description

Hi,

Iam already connected mongodb using json model file in apache calcite.

but here while executing select * from "tablename" it will be showing exceptions.

instead of that query iam  using select  _MAP['columnname'] from 'tablename' then it will be perfectly executing .But i need to select all the columns what is the query.

Another one is i try to perform sql joins in mongodb but it will be not working.how to acheive this task.

{
  "version": "1.0",
  "defaultSchema": "MONGODATABASE",
  "schemas": [
    {
       "type": "custom",
       "name": "MONGODATABASE",
      "factory": "org.apache.calcite.adapter.mongodb.MongoSchemaFactory",
      "operand":

{         "host": "loaclhost",         "database": "db"       }

    }
  ]
}

 

java.calss file:

            Connection connection = DriverManager.getConnection(
                    "jdbc:calcite:model=/home/msubbarao/samplefile2/CalciteWithMongoDb/calcitewithmongo.json", info);
                 Statement stat = connection.createStatement();
            String sql="select * from table1 c  JOIN table2 s on c.name=s.name";
            String sql1="selecT cast(_MAP['columnname'] AS INTEGER(20)) from  \"table\" c  ";
           ResultSet rs = stat.executeQuery(sql);
           
           while(rs.next())

{                System.out.println("-->"+rs.getString(1));            }