Can you query top level directory i.e. /datalake ? Thanks, Padma
> On Sep 13, 2017, at 11:43 PM, Chetan Kothari <chetan.koth...@oracle.com> > wrote: > > I have registered plug-in to connect to container of Oracle Storage Cloud > Service using Swift library. > > I am able to query files present in top level in container of Oracle Storage > Cloud Service. > > > > For example - oscs.`select * from test_tsv` ( test_tsv is file present as > objet in container I configured in storage plug-in ) > > > > But I am not able to query tsv/parquet file having deep hierarchy present in > container configured in storage plug-in. > > for example, when I query, /datalake/replicator/test/requisition_fact/, it > always gives me following error > > > > Sep 13, 2017 11:39:00 PM org.apache.calcite.runtime.CalciteException <init> > > SEVERE: org.apache.calcite.runtime.CalciteContextException: > > From line 1, column 15 to line 1, column 18: Table > 'oscs./datalake/replicator/test/test_requisition_fact' not found > > Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 18: Table > 'oscs./datalake/replicator/test/requisition_fact' not found > > > > SQL Query null > > > > [Error Id: ad55afb5-ea9f-4a9d-95f7-c5a08f712c73 on > slc05gmy.us.oracle.com:31010] (state=,code=0) > > > > Any input on this will be useful. > > > > Regards > > Chetan > >