You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by Rahul Raj <ra...@gmail.com> on 2016/04/23 05:27:32 UTC

Help on translating table name

Asking for help in this group as I could not figure out much from the
examples provided.

I need to translate a query like: 'select * from /path/to/my_table' to

'select * from /path/to/mount/my_table', where the query could be any valid
sql.

Rahul

Re: Help on translating table name

Posted by Rahul Raj <ra...@gmail.com>.
Thanks. I will post my further questions in drill list.

Rahul

On Mon, Apr 25, 2016 at 5:25 AM, Julian Hyde <jh...@apache.org> wrote:

> I think this thread should be in the Drill list. Path names in tables is
> not supported by Calcite.
>
> Julian
>
>
> > On Apr 24, 2016, at 7:42 AM, Ted Dunning <te...@gmail.com> wrote:
> >
> > I was suggesting a single workspace that is sensitive to the content of a
> > property that could be set according to user id.
> >
> >
> >
> > On Sun, Apr 24, 2016 at 11:57 AM, Rahul Raj <ra...@gmail.com> wrote:
> >
> >> One workspace per user might be difficult to maintain with the
> increasing
> >> number of users.
> >>
> >> We are evaluating the possibility of hundreds of users(and more)
> connecting
> >> and executing queries on a single workspace. The users will be
> maintained
> >> by a web application and the queries will be modified based on the home
> >> folder(which will be the registered user id).
> >>
> >> Rahul
> >>
> >> On Sun, Apr 24, 2016 at 1:02 PM, Ted Dunning <te...@gmail.com>
> >> wrote:
> >>
> >>> Have you looked at what Drill does in this way?
> >>>
> >>> In particular, it has workspaces which could plausibly look at
> >> environment
> >>> variables to introduce a home directory path.
> >>>
> >>> In fact, is there a strong reason not to use Drill for this?
> >>>
> >>> On Sun, Apr 24, 2016 at 3:47 AM, Rahul Raj <ra...@gmail.com> wrote:
> >>>
> >>>> We are building a UI application where users can login and query files
> >>>> placed on their respective "home folders". A java application server
> >>>> maintains user information and connects to drill to execute queries.
> >> The
> >>>> files are persisted on a mounted disk, each user having a separate
> >>> folder.
> >>>> The app server modifies the user queries to add the user 'home folder'
> >>>> name.
> >>>>
> >>>> If user1 issues  'select * from /path/to/file1.csv', it must get
> mapped
> >>> to
> >>>> 'select * from /mnt/users/user1/path/to/file1.csv'
> >>>> For user2  query 'select * from /path/to/file1.csv', should map to
> >>> 'select
> >>>> * from /mnt/users/user2/path/to/file1.csv'
> >>>>
> >>>> I am trying to embed calcite in the server application and map the
> >>> queries.
> >>>> I tried some examples using calcite, but could not proceed much.
> >>>>
> >>>> Rahul
> >>>>
> >>>>
> >>>>
> >>>>
> >>>> On Sun, Apr 24, 2016 at 12:30 AM, Ted Dunning <te...@gmail.com>
> >>>> wrote:
> >>>>
> >>>>> When you say translate, do you mean to have the query translated by
> >>> magic
> >>>>> somehow? Are there constraints you didn't mention?
> >>>>>
> >>>>> Without more context it might be a bit hard to avoid answering with
> >>>> obvious
> >>>>> answers like using a text editor or by putting symbolic paths in your
> >>>> file
> >>>>> system, but presumably, you have tried these.
> >>>>>
> >>>>>
> >>>>>
> >>>>> On Sat, Apr 23, 2016 at 11:09 AM, Rahul Raj <ra...@gmail.com>
> >>> wrote:
> >>>>>
> >>>>>> Yes. We have introduced some bookkeeping functionality and is
> >> backed
> >>> by
> >>>>>> drill.
> >>>>>> On Apr 23, 2016 12:12, "Julian Hyde" <jh...@apache.org> wrote:
> >>>>>>
> >>>>>>> Are you running Drill by any chance? That syntax looks similar to
> >>>>> Drill’s
> >>>>>>> syntax for querying files.
> >>>>>>>
> >>>>>>>> On Apr 22, 2016, at 8:27 PM, Rahul Raj <ra...@gmail.com>
> >>> wrote:
> >>>>>>>>
> >>>>>>>> Asking for help in this group as I could not figure out much
> >> from
> >>>> the
> >>>>>>>> examples provided.
> >>>>>>>>
> >>>>>>>> I need to translate a query like: 'select * from
> >>> /path/to/my_table'
> >>>>> to
> >>>>>>>>
> >>>>>>>> 'select * from /path/to/mount/my_table', where the query could
> >> be
> >>>> any
> >>>>>>> valid
> >>>>>>>> sql.
> >>>>>>>>
> >>>>>>>> Rahul
> >>>>>>>
> >>>>>>>
> >>>>>>
> >>>>>
> >>>>
> >>>>
> >>>>
> >>>> --
> >>>> <a href="http://www.spreadfirefox.com/?q=affiliates&id=0&t=1
> >> "><textarea
> >>>> rows="3" cols="40"><a href="
> >>>> http://www.spreadfirefox.com/?q=affiliates&id=0&t=1">Get Firefox!</a>
> >>>>
> >>>
> >>
> >>
> >>
> >> --
> >> <a href="http://www.spreadfirefox.com/?q=affiliates&id=0&t=1"><textarea
> >> rows="3" cols="40"><a href="
> >> http://www.spreadfirefox.com/?q=affiliates&id=0&t=1">Get Firefox!</a>
> >>
>
>


-- 
<a href="http://www.spreadfirefox.com/?q=affiliates&id=0&t=1"><textarea
rows="3" cols="40"><a href="
http://www.spreadfirefox.com/?q=affiliates&id=0&t=1">Get Firefox!</a>

Re: Help on translating table name

Posted by Julian Hyde <jh...@apache.org>.
I think this thread should be in the Drill list. Path names in tables is not supported by Calcite.

Julian


> On Apr 24, 2016, at 7:42 AM, Ted Dunning <te...@gmail.com> wrote:
> 
> I was suggesting a single workspace that is sensitive to the content of a
> property that could be set according to user id.
> 
> 
> 
> On Sun, Apr 24, 2016 at 11:57 AM, Rahul Raj <ra...@gmail.com> wrote:
> 
>> One workspace per user might be difficult to maintain with the increasing
>> number of users.
>> 
>> We are evaluating the possibility of hundreds of users(and more) connecting
>> and executing queries on a single workspace. The users will be maintained
>> by a web application and the queries will be modified based on the home
>> folder(which will be the registered user id).
>> 
>> Rahul
>> 
>> On Sun, Apr 24, 2016 at 1:02 PM, Ted Dunning <te...@gmail.com>
>> wrote:
>> 
>>> Have you looked at what Drill does in this way?
>>> 
>>> In particular, it has workspaces which could plausibly look at
>> environment
>>> variables to introduce a home directory path.
>>> 
>>> In fact, is there a strong reason not to use Drill for this?
>>> 
>>> On Sun, Apr 24, 2016 at 3:47 AM, Rahul Raj <ra...@gmail.com> wrote:
>>> 
>>>> We are building a UI application where users can login and query files
>>>> placed on their respective "home folders". A java application server
>>>> maintains user information and connects to drill to execute queries.
>> The
>>>> files are persisted on a mounted disk, each user having a separate
>>> folder.
>>>> The app server modifies the user queries to add the user 'home folder'
>>>> name.
>>>> 
>>>> If user1 issues  'select * from /path/to/file1.csv', it must get mapped
>>> to
>>>> 'select * from /mnt/users/user1/path/to/file1.csv'
>>>> For user2  query 'select * from /path/to/file1.csv', should map to
>>> 'select
>>>> * from /mnt/users/user2/path/to/file1.csv'
>>>> 
>>>> I am trying to embed calcite in the server application and map the
>>> queries.
>>>> I tried some examples using calcite, but could not proceed much.
>>>> 
>>>> Rahul
>>>> 
>>>> 
>>>> 
>>>> 
>>>> On Sun, Apr 24, 2016 at 12:30 AM, Ted Dunning <te...@gmail.com>
>>>> wrote:
>>>> 
>>>>> When you say translate, do you mean to have the query translated by
>>> magic
>>>>> somehow? Are there constraints you didn't mention?
>>>>> 
>>>>> Without more context it might be a bit hard to avoid answering with
>>>> obvious
>>>>> answers like using a text editor or by putting symbolic paths in your
>>>> file
>>>>> system, but presumably, you have tried these.
>>>>> 
>>>>> 
>>>>> 
>>>>> On Sat, Apr 23, 2016 at 11:09 AM, Rahul Raj <ra...@gmail.com>
>>> wrote:
>>>>> 
>>>>>> Yes. We have introduced some bookkeeping functionality and is
>> backed
>>> by
>>>>>> drill.
>>>>>> On Apr 23, 2016 12:12, "Julian Hyde" <jh...@apache.org> wrote:
>>>>>> 
>>>>>>> Are you running Drill by any chance? That syntax looks similar to
>>>>> Drill’s
>>>>>>> syntax for querying files.
>>>>>>> 
>>>>>>>> On Apr 22, 2016, at 8:27 PM, Rahul Raj <ra...@gmail.com>
>>> wrote:
>>>>>>>> 
>>>>>>>> Asking for help in this group as I could not figure out much
>> from
>>>> the
>>>>>>>> examples provided.
>>>>>>>> 
>>>>>>>> I need to translate a query like: 'select * from
>>> /path/to/my_table'
>>>>> to
>>>>>>>> 
>>>>>>>> 'select * from /path/to/mount/my_table', where the query could
>> be
>>>> any
>>>>>>> valid
>>>>>>>> sql.
>>>>>>>> 
>>>>>>>> Rahul
>>>>>>> 
>>>>>>> 
>>>>>> 
>>>>> 
>>>> 
>>>> 
>>>> 
>>>> --
>>>> <a href="http://www.spreadfirefox.com/?q=affiliates&id=0&t=1
>> "><textarea
>>>> rows="3" cols="40"><a href="
>>>> http://www.spreadfirefox.com/?q=affiliates&id=0&t=1">Get Firefox!</a>
>>>> 
>>> 
>> 
>> 
>> 
>> --
>> <a href="http://www.spreadfirefox.com/?q=affiliates&id=0&t=1"><textarea
>> rows="3" cols="40"><a href="
>> http://www.spreadfirefox.com/?q=affiliates&id=0&t=1">Get Firefox!</a>
>> 


Re: Help on translating table name

Posted by Ted Dunning <te...@gmail.com>.
I was suggesting a single workspace that is sensitive to the content of a
property that could be set according to user id.



On Sun, Apr 24, 2016 at 11:57 AM, Rahul Raj <ra...@gmail.com> wrote:

> One workspace per user might be difficult to maintain with the increasing
> number of users.
>
> We are evaluating the possibility of hundreds of users(and more) connecting
> and executing queries on a single workspace. The users will be maintained
> by a web application and the queries will be modified based on the home
> folder(which will be the registered user id).
>
> Rahul
>
> On Sun, Apr 24, 2016 at 1:02 PM, Ted Dunning <te...@gmail.com>
> wrote:
>
> > Have you looked at what Drill does in this way?
> >
> > In particular, it has workspaces which could plausibly look at
> environment
> > variables to introduce a home directory path.
> >
> > In fact, is there a strong reason not to use Drill for this?
> >
> > On Sun, Apr 24, 2016 at 3:47 AM, Rahul Raj <ra...@gmail.com> wrote:
> >
> > > We are building a UI application where users can login and query files
> > > placed on their respective "home folders". A java application server
> > > maintains user information and connects to drill to execute queries.
> The
> > > files are persisted on a mounted disk, each user having a separate
> > folder.
> > > The app server modifies the user queries to add the user 'home folder'
> > > name.
> > >
> > > If user1 issues  'select * from /path/to/file1.csv', it must get mapped
> > to
> > > 'select * from /mnt/users/user1/path/to/file1.csv'
> > > For user2  query 'select * from /path/to/file1.csv', should map to
> > 'select
> > > * from /mnt/users/user2/path/to/file1.csv'
> > >
> > > I am trying to embed calcite in the server application and map the
> > queries.
> > > I tried some examples using calcite, but could not proceed much.
> > >
> > > Rahul
> > >
> > >
> > >
> > >
> > > On Sun, Apr 24, 2016 at 12:30 AM, Ted Dunning <te...@gmail.com>
> > > wrote:
> > >
> > > > When you say translate, do you mean to have the query translated by
> > magic
> > > > somehow? Are there constraints you didn't mention?
> > > >
> > > > Without more context it might be a bit hard to avoid answering with
> > > obvious
> > > > answers like using a text editor or by putting symbolic paths in your
> > > file
> > > > system, but presumably, you have tried these.
> > > >
> > > >
> > > >
> > > > On Sat, Apr 23, 2016 at 11:09 AM, Rahul Raj <ra...@gmail.com>
> > wrote:
> > > >
> > > > > Yes. We have introduced some bookkeeping functionality and is
> backed
> > by
> > > > > drill.
> > > > > On Apr 23, 2016 12:12, "Julian Hyde" <jh...@apache.org> wrote:
> > > > >
> > > > > > Are you running Drill by any chance? That syntax looks similar to
> > > > Drill’s
> > > > > > syntax for querying files.
> > > > > >
> > > > > > > On Apr 22, 2016, at 8:27 PM, Rahul Raj <ra...@gmail.com>
> > wrote:
> > > > > > >
> > > > > > > Asking for help in this group as I could not figure out much
> from
> > > the
> > > > > > > examples provided.
> > > > > > >
> > > > > > > I need to translate a query like: 'select * from
> > /path/to/my_table'
> > > > to
> > > > > > >
> > > > > > > 'select * from /path/to/mount/my_table', where the query could
> be
> > > any
> > > > > > valid
> > > > > > > sql.
> > > > > > >
> > > > > > > Rahul
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> > >
> > >
> > > --
> > > <a href="http://www.spreadfirefox.com/?q=affiliates&id=0&t=1
> "><textarea
> > > rows="3" cols="40"><a href="
> > > http://www.spreadfirefox.com/?q=affiliates&id=0&t=1">Get Firefox!</a>
> > >
> >
>
>
>
> --
> <a href="http://www.spreadfirefox.com/?q=affiliates&id=0&t=1"><textarea
> rows="3" cols="40"><a href="
> http://www.spreadfirefox.com/?q=affiliates&id=0&t=1">Get Firefox!</a>
>

Re: Help on translating table name

Posted by Rahul Raj <ra...@gmail.com>.
One workspace per user might be difficult to maintain with the increasing
number of users.

We are evaluating the possibility of hundreds of users(and more) connecting
and executing queries on a single workspace. The users will be maintained
by a web application and the queries will be modified based on the home
folder(which will be the registered user id).

Rahul

On Sun, Apr 24, 2016 at 1:02 PM, Ted Dunning <te...@gmail.com> wrote:

> Have you looked at what Drill does in this way?
>
> In particular, it has workspaces which could plausibly look at environment
> variables to introduce a home directory path.
>
> In fact, is there a strong reason not to use Drill for this?
>
> On Sun, Apr 24, 2016 at 3:47 AM, Rahul Raj <ra...@gmail.com> wrote:
>
> > We are building a UI application where users can login and query files
> > placed on their respective "home folders". A java application server
> > maintains user information and connects to drill to execute queries. The
> > files are persisted on a mounted disk, each user having a separate
> folder.
> > The app server modifies the user queries to add the user 'home folder'
> > name.
> >
> > If user1 issues  'select * from /path/to/file1.csv', it must get mapped
> to
> > 'select * from /mnt/users/user1/path/to/file1.csv'
> > For user2  query 'select * from /path/to/file1.csv', should map to
> 'select
> > * from /mnt/users/user2/path/to/file1.csv'
> >
> > I am trying to embed calcite in the server application and map the
> queries.
> > I tried some examples using calcite, but could not proceed much.
> >
> > Rahul
> >
> >
> >
> >
> > On Sun, Apr 24, 2016 at 12:30 AM, Ted Dunning <te...@gmail.com>
> > wrote:
> >
> > > When you say translate, do you mean to have the query translated by
> magic
> > > somehow? Are there constraints you didn't mention?
> > >
> > > Without more context it might be a bit hard to avoid answering with
> > obvious
> > > answers like using a text editor or by putting symbolic paths in your
> > file
> > > system, but presumably, you have tried these.
> > >
> > >
> > >
> > > On Sat, Apr 23, 2016 at 11:09 AM, Rahul Raj <ra...@gmail.com>
> wrote:
> > >
> > > > Yes. We have introduced some bookkeeping functionality and is backed
> by
> > > > drill.
> > > > On Apr 23, 2016 12:12, "Julian Hyde" <jh...@apache.org> wrote:
> > > >
> > > > > Are you running Drill by any chance? That syntax looks similar to
> > > Drill’s
> > > > > syntax for querying files.
> > > > >
> > > > > > On Apr 22, 2016, at 8:27 PM, Rahul Raj <ra...@gmail.com>
> wrote:
> > > > > >
> > > > > > Asking for help in this group as I could not figure out much from
> > the
> > > > > > examples provided.
> > > > > >
> > > > > > I need to translate a query like: 'select * from
> /path/to/my_table'
> > > to
> > > > > >
> > > > > > 'select * from /path/to/mount/my_table', where the query could be
> > any
> > > > > valid
> > > > > > sql.
> > > > > >
> > > > > > Rahul
> > > > >
> > > > >
> > > >
> > >
> >
> >
> >
> > --
> > <a href="http://www.spreadfirefox.com/?q=affiliates&id=0&t=1"><textarea
> > rows="3" cols="40"><a href="
> > http://www.spreadfirefox.com/?q=affiliates&id=0&t=1">Get Firefox!</a>
> >
>



-- 
<a href="http://www.spreadfirefox.com/?q=affiliates&id=0&t=1"><textarea
rows="3" cols="40"><a href="
http://www.spreadfirefox.com/?q=affiliates&id=0&t=1">Get Firefox!</a>

Re: Help on translating table name

Posted by Ted Dunning <te...@gmail.com>.
Have you looked at what Drill does in this way?

In particular, it has workspaces which could plausibly look at environment
variables to introduce a home directory path.

In fact, is there a strong reason not to use Drill for this?

On Sun, Apr 24, 2016 at 3:47 AM, Rahul Raj <ra...@gmail.com> wrote:

> We are building a UI application where users can login and query files
> placed on their respective "home folders". A java application server
> maintains user information and connects to drill to execute queries. The
> files are persisted on a mounted disk, each user having a separate folder.
> The app server modifies the user queries to add the user 'home folder'
> name.
>
> If user1 issues  'select * from /path/to/file1.csv', it must get mapped to
> 'select * from /mnt/users/user1/path/to/file1.csv'
> For user2  query 'select * from /path/to/file1.csv', should map to 'select
> * from /mnt/users/user2/path/to/file1.csv'
>
> I am trying to embed calcite in the server application and map the queries.
> I tried some examples using calcite, but could not proceed much.
>
> Rahul
>
>
>
>
> On Sun, Apr 24, 2016 at 12:30 AM, Ted Dunning <te...@gmail.com>
> wrote:
>
> > When you say translate, do you mean to have the query translated by magic
> > somehow? Are there constraints you didn't mention?
> >
> > Without more context it might be a bit hard to avoid answering with
> obvious
> > answers like using a text editor or by putting symbolic paths in your
> file
> > system, but presumably, you have tried these.
> >
> >
> >
> > On Sat, Apr 23, 2016 at 11:09 AM, Rahul Raj <ra...@gmail.com> wrote:
> >
> > > Yes. We have introduced some bookkeeping functionality and is backed by
> > > drill.
> > > On Apr 23, 2016 12:12, "Julian Hyde" <jh...@apache.org> wrote:
> > >
> > > > Are you running Drill by any chance? That syntax looks similar to
> > Drill’s
> > > > syntax for querying files.
> > > >
> > > > > On Apr 22, 2016, at 8:27 PM, Rahul Raj <ra...@gmail.com> wrote:
> > > > >
> > > > > Asking for help in this group as I could not figure out much from
> the
> > > > > examples provided.
> > > > >
> > > > > I need to translate a query like: 'select * from /path/to/my_table'
> > to
> > > > >
> > > > > 'select * from /path/to/mount/my_table', where the query could be
> any
> > > > valid
> > > > > sql.
> > > > >
> > > > > Rahul
> > > >
> > > >
> > >
> >
>
>
>
> --
> <a href="http://www.spreadfirefox.com/?q=affiliates&id=0&t=1"><textarea
> rows="3" cols="40"><a href="
> http://www.spreadfirefox.com/?q=affiliates&id=0&t=1">Get Firefox!</a>
>

Re: Help on translating table name

Posted by Rahul Raj <ra...@gmail.com>.
We are building a UI application where users can login and query files
placed on their respective "home folders". A java application server
maintains user information and connects to drill to execute queries. The
files are persisted on a mounted disk, each user having a separate folder.
The app server modifies the user queries to add the user 'home folder'
name.

If user1 issues  'select * from /path/to/file1.csv', it must get mapped to
'select * from /mnt/users/user1/path/to/file1.csv'
For user2  query 'select * from /path/to/file1.csv', should map to 'select
* from /mnt/users/user2/path/to/file1.csv'

I am trying to embed calcite in the server application and map the queries.
I tried some examples using calcite, but could not proceed much.

Rahul




On Sun, Apr 24, 2016 at 12:30 AM, Ted Dunning <te...@gmail.com> wrote:

> When you say translate, do you mean to have the query translated by magic
> somehow? Are there constraints you didn't mention?
>
> Without more context it might be a bit hard to avoid answering with obvious
> answers like using a text editor or by putting symbolic paths in your file
> system, but presumably, you have tried these.
>
>
>
> On Sat, Apr 23, 2016 at 11:09 AM, Rahul Raj <ra...@gmail.com> wrote:
>
> > Yes. We have introduced some bookkeeping functionality and is backed by
> > drill.
> > On Apr 23, 2016 12:12, "Julian Hyde" <jh...@apache.org> wrote:
> >
> > > Are you running Drill by any chance? That syntax looks similar to
> Drill’s
> > > syntax for querying files.
> > >
> > > > On Apr 22, 2016, at 8:27 PM, Rahul Raj <ra...@gmail.com> wrote:
> > > >
> > > > Asking for help in this group as I could not figure out much from the
> > > > examples provided.
> > > >
> > > > I need to translate a query like: 'select * from /path/to/my_table'
> to
> > > >
> > > > 'select * from /path/to/mount/my_table', where the query could be any
> > > valid
> > > > sql.
> > > >
> > > > Rahul
> > >
> > >
> >
>



-- 
<a href="http://www.spreadfirefox.com/?q=affiliates&id=0&t=1"><textarea
rows="3" cols="40"><a href="
http://www.spreadfirefox.com/?q=affiliates&id=0&t=1">Get Firefox!</a>

Re: Help on translating table name

Posted by Ted Dunning <te...@gmail.com>.
When you say translate, do you mean to have the query translated by magic
somehow? Are there constraints you didn't mention?

Without more context it might be a bit hard to avoid answering with obvious
answers like using a text editor or by putting symbolic paths in your file
system, but presumably, you have tried these.



On Sat, Apr 23, 2016 at 11:09 AM, Rahul Raj <ra...@gmail.com> wrote:

> Yes. We have introduced some bookkeeping functionality and is backed by
> drill.
> On Apr 23, 2016 12:12, "Julian Hyde" <jh...@apache.org> wrote:
>
> > Are you running Drill by any chance? That syntax looks similar to Drill’s
> > syntax for querying files.
> >
> > > On Apr 22, 2016, at 8:27 PM, Rahul Raj <ra...@gmail.com> wrote:
> > >
> > > Asking for help in this group as I could not figure out much from the
> > > examples provided.
> > >
> > > I need to translate a query like: 'select * from /path/to/my_table' to
> > >
> > > 'select * from /path/to/mount/my_table', where the query could be any
> > valid
> > > sql.
> > >
> > > Rahul
> >
> >
>

Re: Help on translating table name

Posted by Rahul Raj <ra...@gmail.com>.
Yes. We have introduced some bookkeeping functionality and is backed by
drill.
On Apr 23, 2016 12:12, "Julian Hyde" <jh...@apache.org> wrote:

> Are you running Drill by any chance? That syntax looks similar to Drill’s
> syntax for querying files.
>
> > On Apr 22, 2016, at 8:27 PM, Rahul Raj <ra...@gmail.com> wrote:
> >
> > Asking for help in this group as I could not figure out much from the
> > examples provided.
> >
> > I need to translate a query like: 'select * from /path/to/my_table' to
> >
> > 'select * from /path/to/mount/my_table', where the query could be any
> valid
> > sql.
> >
> > Rahul
>
>

Re: Help on translating table name

Posted by Julian Hyde <jh...@apache.org>.
Are you running Drill by any chance? That syntax looks similar to Drill’s syntax for querying files.

> On Apr 22, 2016, at 8:27 PM, Rahul Raj <ra...@gmail.com> wrote:
> 
> Asking for help in this group as I could not figure out much from the
> examples provided.
> 
> I need to translate a query like: 'select * from /path/to/my_table' to
> 
> 'select * from /path/to/mount/my_table', where the query could be any valid
> sql.
> 
> Rahul