Re: Question about exposing tables and columns
Hey Dilip, I don't think your attachment made it through, due to moderation. Can you try uploading it as a gist on GitHub? Francis On 29/03/2024 7:50 am, Dilip Patel wrote: Hi We have a data warehouse, and I want to expose only selected tables from the DW and create a virtual database. I aim to allow the consumer to query these tables via the JDBC driver. I came across the Calcite and Avatica libraries and they seem to be capable of doing this. I was able to connect to the Datawarehouse database and expose all the tables and columns using Avatica running as a server. However, despite my best efforts, I couldn't find a way to expose only certain tables and their columns. Can you provide some examples of how to do this? I have attached the code. I have implemented custom meta, but I am still unable to invoke the getTables function (I believe it is called by the Avatica framework itself ) So that you know, the implementation is just rough to get my feet wet with Calcite and Avatica. Thank you, Dilip
Re: Question about exposing tables and columns
Also here is the client-side code: String sql = "select * from ddw_fact_realtime_metric"; Connection connection = null; Statement statement = null; try { connection = DriverManager.getConnection("jdbc:avatica:remote:url=http://localhost:9787;serialization=PROTOBUF";); statement = connection.createStatement(); try { final ResultSet resultSet = statement.executeQuery( sql); output(resultSet); }catch (Exception e) { e.printStackTrace(); } } finally { close(connection, statement); } On Thu, Mar 28, 2024 at 4:50 PM Dilip Patel wrote: > Hi > > We have a data warehouse, and I want to expose only selected tables from > the DW and create a virtual database. I aim to allow the consumer to query > these tables via the JDBC driver. I came across the Calcite and Avatica > libraries and they seem to be capable of doing this. > > I was able to connect to the Datawarehouse database and expose all the > tables and columns using Avatica running as a server. However, despite my > best efforts, I couldn't find a way to expose only certain tables and their > columns. Can you provide some examples of how to do this? > > I have attached the code. I have implemented custom meta, but I am still > unable to invoke the getTables function (I believe it is called by the > Avatica framework itself ) > > So that you know, the implementation is just rough to get my feet wet with > Calcite and Avatica. > > Thank you, > Dilip > >