Mailing-List: contact dev-help@calcite.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@calcite.apache.org
MIME-Version: 1.0
From: deepak pushpakar <deepak.pushpakar@gmail.com>
Date: Fri, 4 Dec 2015 22:25:50 +0530
Message-ID: 
 <CANnm-A1wxvK8auxLVXigPVcVUo=5pK-W0cAVicXKfORQUcXphQ@mail.gmail.com>
Subject: Date Functions in calcite - MONTH($date)
To: dev@calcite.apache.org
Content-Type: multipart/alternative; boundary=089e011616828f3b0405261563ab

--089e011616828f3b0405261563ab
Content-Type: text/plain; charset=UTF-8

Hello Calcite Developers,

   We are using Calcite for validation and parsing of hive queries. When we
try to include a MONTH() function in one of the select columns the query,
the query fails telling that it is not expected. I went through the code
base of 1.4.0 and 1.50 trying to understand what I can do myself by doing
some change and building it. I also found that MONTH function is not yet
implemented (mentioned in the calcite website.
Any help appreciated.
Example query:
SELECT MONTH($DATE_COLUMN) AS MONTH_ID, COUNT($DATA_COLUMN) AS NUM_RECORDS
FROM $RECORDS_TABLE WHERE $COL1 = 'SOME_VALUE' GROUP BY MONTH_ID ORDER BY
NUM_RECORDS;


Thanks
Deepak Pushpakar

--089e011616828f3b0405261563ab--