SQL Advisor help

2019-01-10 Thread Rahul Raj
Can anyone point me to a standalone example of SQL Advisor? I went through the test cases, but the test setups were slightly complicated to understand. I am trying to build a SQL code completion support with schema, table and column information known. Regards, Rahul

Re: SQL Advisor help

2019-01-10 Thread Rahul Raj
st results = advisor.getCompletionHints(sql, sap.cursor, new String[]{null}); I am wondering where I can feed the schema/table information in the code. Regards, Rahul On Thu, Jan 10, 2019 at 4:03 PM Vladimir Sitnikov < sitnikov.vladi...@gmail.com> wrote: > Rahul Raj > Can anyone point me to a

Re: SQL Advisor help

2019-01-10 Thread Rahul Raj
That was my guess too. I debugged by putting break points across MySqlValidatorCatalogReader methods, but didnt help. On Thu, Jan 10, 2019 at 5:48 PM Vladimir Sitnikov < sitnikov.vladi...@gmail.com> wrote: > > I am just using the parser only. Based on the test cases I wrote the > > following code

Re: SQL Advisor help

2019-01-10 Thread Rahul Raj
Could you have a look at https://github.com/rajrahul/sqlhint/tree/master/src/main/java ? Regards, Rahul On Thu, Jan 10, 2019 at 8:43 PM Vladimir Sitnikov < sitnikov.vladi...@gmail.com> wrote: > Would you please share the code? > Otherwise it is hard to guess which line should be adjusted > > Vla

Help on translating table name

2016-04-22 Thread Rahul Raj
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

2016-04-23 Thread Rahul Raj
Yes. We have introduced some bookkeeping functionality and is backed by drill. On Apr 23, 2016 12:12, "Julian Hyde" 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 R

Re: Help on translating table name

2016-04-23 Thread Rahul Raj
tem, but presumably, you have tried these. > > > > On Sat, Apr 23, 2016 at 11:09 AM, Rahul Raj wrote: > > > Yes. We have introduced some bookkeeping functionality and is backed by > > drill. > > On Apr 23, 2016 12:12, "Julian Hyde" wrote: > > > > &g

Re: Help on translating table name

2016-04-24 Thread Rahul Raj
rectory 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 wrote: > > > We are building a UI application where users can login and query files > > placed on their respective "home folders&qu

Re: Help on translating table name

2016-04-24 Thread Rahul Raj
unning 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 wrote: > > > >> One workspace p

Apache Drill/Calcite error on Date manipulation

2017-12-07 Thread Rahul Raj
Hi All, This is an issue related to Apache Drill and need some help to debug the problem. Drill supports a feature to query a database directly. When querying a database directly, Drill throws an exception while manipulating a date field inside the 'where' clause as shown in the query below: sel

Re: Apache Drill/Calcite error on Date manipulation

2018-02-16 Thread Rahul Raj
t; > > On Dec 7, 2017, at 11:11 PM, Rahul Raj wrote: > > > > Hi All, > > > > This is an issue related to Apache Drill and need some help to debug the > > problem. > > > > Drill supports a feature to query a database directly. When querying a > > da

Re: Apache Drill/Calcite error on Date manipulation

2018-02-19 Thread Rahul Raj
develop a fix, if you are able to. > > > On Feb 16, 2018, at 4:11 AM, Rahul Raj wrote: > > > > I tested it on Drill 1.13 branch having the latest calcite changes merged > > in. It throws an unsupported operation exception, should I raise a > Calcite > > tic

Re: Apache Drill/Calcite error on Date manipulation

2018-02-20 Thread Rahul Raj
dialects of > SQL. SqlParserTest tests Calcite’s dialect. So maybe you need to change how > interval literals are unparsed for MySQL’s dialect only. > > Julian > > > > On Feb 19, 2018, at 9:25 PM, Rahul Raj wrote: > > > > I have a got a fix ready, the issues wa

[jira] [Created] (CALCITE-2188) Calcite errors on Date interval addition/subtraction in the where clause

2018-02-20 Thread Rahul Raj (JIRA)
Rahul Raj created CALCITE-2188: -- Summary: Calcite errors on Date interval addition/subtraction in the where clause Key: CALCITE-2188 URL: https://issues.apache.org/jira/browse/CALCITE-2188 Project