[jira] [Created] (CALCITE-2371) how to perform joins in mongodb using model json in calcite

["Subbarao (JIRA)" <ji...@apache.org>]

Subbarao created CALCITE-2371:
---------------------------------

             Summary: how to perform joins in mongodb using model json in calcite
                 Key: CALCITE-2371
                 URL: https://issues.apache.org/jira/browse/CALCITE-2371
             Project: Calcite
          Issue Type: Task
            Reporter: Subbarao
            Assignee: Julian Hyde


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));
           }

 

 

 

 

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)