[ https://issues.apache.org/jira/browse/CALCITE-2371?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16518072#comment-16518072 ]
Michael Mior commented on CALCITE-2371: --------------------------------------- If you have questions about how to use Calcite, try asking on the mailing list, d...@calcite.apache.org. This bug tracker is used for reporting issues and tracking new features. > 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 > Priority: Major > > 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)