1. Could you give an example of what your expected output/query is here?
I'm not sure what you're trying to achieve.
2. There are mappings in MysqlSqlDialect.java from Calcite FLOOR to Mysql
DATE_FORMAT. So what you want in your RelNode is something like
FLOOR(HIRE_DATE TO day)
On Tue, Mar 5, 2019 at 6:41 PM Rakesh Nair <ramkrs...@gmail.com> wrote:
> Hi,
> Sorry to be a bother, but I've been sitting on this for quite a while now
> and would really like to clear it. So I've been trying to use the
> RelBuilder for building relational expressions.
> 1. I'm trying to build the relational expressions for using Trim()
> function. This si what I've done so far:
> RelNode node =
> builder.scan("emp").project(builder.call(SqlStdOperatorTable.TRIM,
> builder.getRexBuilder().makeFlag(Flag.BOTH),builder.literal(" "),
> builder.field("EMPNAME"))).build();
> Query Explain:
> LogicalProject($f0=[TRIM(FLAG(BOTH), ' ', $2)])
> LogicalTableScan(table=[[hr, emp]])
> Corresponding Mysql Query:
> SELECT TRIM(BOTH ' ' FROM `EMPNAME`) AS `$f0`
> FROM `hr`.`emp`
> Could somebody tell me what I'm doing wrong here?
> 2. How can I convert the following Mysql Query:
> SELECT DATE_FORMAT(HIRE_DATE,'%Y/%m/%d'), EMPNAME FROM `emp` WHERE
> DATE_FORMAT(HIRE_DATE,'%Y/%m/%d') = DATE_FORMAT(NOW(),'%Y/%m/%d');
> to its corresponding Relational Algebra using RelBuilder? Simply put how
> can i convert the date formats in RelBuilder?
>
> Thanks and Regards,
> RamKrishna.
>
--
*Christopher Baynes*
Lead Developer
*Contiamo – all your data in one place*
Stresemannstraße 123 (c/o WeWork) | 10963 Berlin | Germany
E-mail: ch...@contiamo.com
Web: www.contiamo.com
<http://t.sidekickopen65.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJW7t5XZs4X9YtjW8q-fZW65jv3RW2zhrDH56dLV8f5DKhvM02?t=http%3A%2F%2Fwww.contiamo.com%2F&si=5165279625740288&pi=bff9f6a3-d8a4-4bf6-87d5-a5464041547d>
Contiamo GmbH, Sitz der Gesellschaft: Berlin
HR Berlin-Charlottenburg, HRB Nr. 156569
Geschäftsführer: Lucia Hegenbartova, Michael Franzkowiak
