hongbin ma created CALCITE-1754:
---
Summary: queries grouping by timestampadd throws ClassCastException
Key: CALCITE-1754
URL: https://issues.apache.org/jira/browse/CALCITE-1754
Project: Calcite
at sql spec side, I tried to find sth related in
http://jtc1sc32.org/doc/N2301-2350/32N2311T-text_for_ballot-CD_9075-2.pdf,
especially in section 4.6, but nothing is found. If you found sth pls let
me know
On Fri, Feb 17, 2017 at 3:24 PM, hongbin ma wrote:
> hi julian
>
> on postgre
nd some
> committee drafts. Not the final standard, but good enough for our purposes.
>
> Julian
>
> > On Feb 16, 2017, at 12:37 AM, hongbin ma wrote:
> >
> > Hi Julian
> >
> > Thanks for you reply.
> >
> > I have confirmed on po
hongbin ma created CALCITE-1639:
---
Summary: issue for timestampadd month
Key: CALCITE-1639
URL: https://issues.apache.org/jira/browse/CALCITE-1639
Project: Calcite
Issue Type: Bug
2016-05-31’ + INTERVAL ‘1’ MONTH. Similarly TIMESTAMPDIFF.
>
> So, can you please investigate whether we got interval addition and
> subtraction wrong too. I think you should check the SQL standard
> (preferably SQL-2011 or SQL-2014 draft) and also test on PostgreSQL.
>
> Julian
>
hi experts
in calcite,
select timestampadd(MONTH,1,cast('2016-05-31' as timestamp)) will
return 2016-07-01 00:00:00, and select
timestampadd(MONTH,-1,cast('2016-03-31' as timestamp)) will
return 2016-03-01 00:00:00
however in mysql, the last day of the next/previous month is always
returned:
E.
>
> Julian
>
>
> > On Feb 7, 2017, at 11:02 PM, hongbin ma wrote:
> >
> > hi experts,
> >
> > According to this doc https://calcite.apache.org/docs/reference.html the
> > EXTRACT function should work in Calcite. So I'm trying a que
hongbin ma created CALCITE-1629:
---
Summary: EXTRACT function not working in CSVTest
Key: CALCITE-1629
URL: https://issues.apache.org/jira/browse/CALCITE-1629
Project: Calcite
Issue Type: Bug
hi experts,
According to this doc https://calcite.apache.org/docs/reference.html the
EXTRACT function should work in Calcite. So I'm trying a query with EXTRACT
in CSVTest:
@Test public void testSelectx() throws SQLException {
checkSql("model", "select extract(year from JOINEDAT) from EMPS ");
hongbin ma created CALCITE-1592:
---
Summary: UnsupportedOperationException for queries with not(not())
filters
Key: CALCITE-1592
URL: https://issues.apache.org/jira/browse/CALCITE-1592
Project: Calcite
hongbin ma created CALCITE-1540:
---
Summary: window function does not support multiple partition
columns
Key: CALCITE-1540
URL: https://issues.apache.org/jira/browse/CALCITE-1540
Project: Calcite
; If you really want this function, contribute a patch.
>
> Julian
>
> [1] https://issues.apache.org/jira/browse/CALCITE-420 <
> https://issues.apache.org/jira/browse/CALCITE-420>
>
> > On Sep 17, 2016, at 5:49 AM, hongbin ma wrote:
> >
> > hi experts
hi experts
recently we need to enable "replace" function for our customer, like
replacing all the X with Y in "123X456X". According to
https://calcite.apache.org/docs/reference.html the replace function seems
not implemented. I see there's another function called "OVERLAY", however
it's replacing
hongbin ma created CALCITE-1375:
---
Summary: Why "select CONCAT('a','b') from EMPS" won't work?
Key: CALCITE-1375
URL: https://issues.apache.org/jira/browse/CALCITE-1375
hongbin ma created CALCITE-1373:
---
Summary: select date column will fail in 1.8.0
Key: CALCITE-1373
URL: https://issues.apache.org/jira/browse/CALCITE-1373
Project: Calcite
Issue Type: Bug
hongbin ma created CALCITE-1351:
---
Summary: "IS [NOT] NULL" operator should have higher precedence
than "NOT" operator
Key: CALCITE-1351
URL: https://issues.apache.org/jira/browse/CALCITE-1351
also interested in this topic, as we have the similar issue in Kylin :)
On Tue, Mar 1, 2016 at 6:20 AM, Julian Hyde wrote:
> Michael Mior would like to upgrade Guava from 14 to 15 so that we can use
> Cassandra 3.0. But I know some projects (e.g. Hive) depend on earlier
> versions. So, how to pl
hi Rajat
this is Hongbin Ma from Apache Kylin, I'm very interested in Quark, which
in my opinion shares a lot in common with Quark. Actually I believe Kylin
it self may benefit from Quark, too. Can you also please share your roadmap
with the community? (People may be very interested i
hi Michael,
this is Hongbin Ma from Apache Kylin (http://kylin.apache.org/), like James
mentioned, Kylin aimed to server OLAP queries by 1. pre-aggregating raw
records and save it into hbase 2. use Calcite to parse the query SQL and
translate it to HBase scans.
AFAIK there're other pro
7 AM, Josh Elser wrote:
> > Hi,
> >
> > Per the "Board report" thread, it sounds like Julian's plan is for 1.6
> later
> > this month. This seems reasonable to me too.
> >
> > - Josh
> >
> >
> > hongbin ma wrote:
> >>
>
20 matches
Mail list logo