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> >>
