Thanks. I will post my further questions in drill list. Rahul
On Mon, Apr 25, 2016 at 5:25 AM, Julian Hyde <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> > >> 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 <[email protected]> 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 <[email protected]> > >>>> 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 <[email protected]> > >>> wrote: > >>>>> > >>>>>> Yes. We have introduced some bookkeeping functionality and is > >> backed > >>> by > >>>>>> drill. > >>>>>> On Apr 23, 2016 12:12, "Julian Hyde" <[email protected]> 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 <[email protected]> > >>> 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>
