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