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)