[GitHub] mayankshriv commented on issue #3626: timezone problem
mayankshriv commented on issue #3626: timezone problem URL: https://github.com/apache/incubator-pinot/issues/3626#issuecomment-450542255 The second statement has EPOCH (which is UTC). Statement 1 is the only way to specify time zone. Seems like you don't have a filter in your query, which means you are essentially applying the transform on all the records. How many records do are there in this table? What is the query latency you are seeing? Also, is this a test query or a real query that you plan to run in production (ie without any filters)? This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services - To unsubscribe, e-mail: dev-unsubscr...@pinot.apache.org For additional commands, e-mail: dev-h...@pinot.apache.org
[GitHub] ly923976094 edited a comment on issue #3626: timezone problem
ly923976094 edited a comment on issue #3626: timezone problem URL: https://github.com/apache/incubator-pinot/issues/3626#issuecomment-450542063 > Pinot has an inbuilt transform function for date-time conversion which supports time zone. You can refer to the following for more details: https://github.com/apache/incubator-pinot/wiki/dateTimeConvert-UDF > > Also, note that transform functions are currently supported in group-by and projection, but not in filter (predicates). Thank you very much for your reply, yes ,The following PQL statement 1 can specify the corresponding time zone with SIMPLE_DATE_FORMAT, but the time conversion of SIMPLE_DATE_FORMAT is very time-consuming, so I want to use sentence 2 to convert the result of query to time, but the time zone cannot be defined pql1: select sum(total) from test group by dateTimeConvert(timestamp, '1:MILLISECONDS:EPOCH','1:MILLISECONDS:SIMPLE_DATE_FORMAT:-MM-dd HH:mm:ss tz(Asia/Shanghai)', '1:DAYS') pql2: select sum(total) from test group by dateTimeConvert(timestamp, '1:MILLISECONDS:EPOCH','1:MILLISECONDS:EPOCH', '1:DAYS') This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services - To unsubscribe, e-mail: dev-unsubscr...@pinot.apache.org For additional commands, e-mail: dev-h...@pinot.apache.org
[GitHub] ly923976094 removed a comment on issue #3626: timezone problem
ly923976094 removed a comment on issue #3626: timezone problem URL: https://github.com/apache/incubator-pinot/issues/3626#issuecomment-450542039 yes , The following PQL statement 1 can specify the corresponding time zone with SIMPLE_DATE_FORMAT, but the time conversion of SIMPLE_DATEFORMAT is very time-consuming, so I want to use sentence 2 to convert the result of query to time, but the time zone cannot be defined pql1: select sum(total) from test group by dateTimeConvert(timestamp, '1:MILLISECONDS:EPOCH','1:MILLISECONDS:SIMPLE_DATE_FORMAT:-MM-dd HH:mm:ss tz(Asia/Shanghai)', '1:DAYS') pql2: select sum(total) from test group by dateTimeConvert(timestamp, '1:MILLISECONDS:EPOCH','1:MILLISECONDS:EPOCH', '1:DAYS') This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services - To unsubscribe, e-mail: dev-unsubscr...@pinot.apache.org For additional commands, e-mail: dev-h...@pinot.apache.org
[GitHub] ly923976094 commented on issue #3626: timezone problem
ly923976094 commented on issue #3626: timezone problem URL: https://github.com/apache/incubator-pinot/issues/3626#issuecomment-450542039 yes , The following PQL statement 1 can specify the corresponding time zone with SIMPLE_DATE_FORMAT, but the time conversion of SIMPLE_DATEFORMAT is very time-consuming, so I want to use sentence 2 to convert the result of query to time, but the time zone cannot be defined pql1: select sum(total) from test group by dateTimeConvert(timestamp, '1:MILLISECONDS:EPOCH','1:MILLISECONDS:SIMPLE_DATE_FORMAT:-MM-dd HH:mm:ss tz(Asia/Shanghai)', '1:DAYS') pql2: select sum(total) from test group by dateTimeConvert(timestamp, '1:MILLISECONDS:EPOCH','1:MILLISECONDS:EPOCH', '1:DAYS') This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services - To unsubscribe, e-mail: dev-unsubscr...@pinot.apache.org For additional commands, e-mail: dev-h...@pinot.apache.org
[GitHub] mayankshriv commented on issue #3626: timezone problem
mayankshriv commented on issue #3626: timezone problem URL: https://github.com/apache/incubator-pinot/issues/3626#issuecomment-450540631 Pinot has an inbuilt transform function for date-time conversion which supports time zone. You can refer to the following for more details: https://github.com/apache/incubator-pinot/wiki/dateTimeConvert-UDF Also, note that transform functions are currently supported in group-by and projection, but not in filter (predicates). This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services - To unsubscribe, e-mail: dev-unsubscr...@pinot.apache.org For additional commands, e-mail: dev-h...@pinot.apache.org
Re: Pinot website and DOAP
Jennifer, can you please take these two JIRAs? https://issues.apache.org/jira/browse/PINOT-3 https://issues.apache.org/jira/browse/PINOT-2 -Subbu From: Felix Cheung Sent: Friday, December 28, 2018 2:54 PM To: dev@pinot.apache.org Subject: Pinot website and DOAP Hello, I’ve opened a PR to update some trademark references on the website https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fapache%2Fincubator-pinot-site%2Fpull%2F4data=02%7C01%7Cssubramaniam%40linkedin.com%7Ced8151eb426d4e1eb9bf08d66d176854%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636816344633912291sdata=OqkxFsVXDrp3NzrqnhfmYgVwv%2F%2Fk1ofadX1LLhVGitM%3Dreserved=0 Also open JIRA on link back https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fissues.apache.org%2Fjira%2Fbrowse%2FPINOT-2data=02%7C01%7Cssubramaniam%40linkedin.com%7Ced8151eb426d4e1eb9bf08d66d176854%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636816344633912291sdata=RLEvKQLCPIWKaV35ZJeO1kJwuzaWArnXvfAtjFvycfA%3Dreserved=0 And JIRA on DOAP https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fissues.apache.org%2Fjira%2Fbrowse%2FPINOT-3data=02%7C01%7Cssubramaniam%40linkedin.com%7Ced8151eb426d4e1eb9bf08d66d176854%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636816344633912291sdata=tpMZ7uupsePFKidd2hX31hUK%2BvKbgkUxGkt4KP%2FyXG8%3Dreserved=0 Regards
Re: Podling Report Reminder - January 2019
Thanks, Felix. Done. -Subbu From: Felix Cheung Sent: Friday, December 28, 2018 6:23 PM To: dev@pinot.apache.org; g.kish...@gmail.com; dev@pinot.apache.org Subject: Re: Podling Report Reminder - January 2019 Thanks Subbu. Is this the first report? If so, you can add: source repo migrated to Apache, mailing lists and JIRA created. Also a website created. Otherwise LGTM From: Subbu Subramaniam Sent: Friday, December 28, 2018 5:12 PM To: g.kish...@gmail.com; dev@pinot.apache.org Subject: Re: Podling Report Reminder - January 2019 Thanks Felix. I have updated the podling page. Please take a look and let me know if there is anything else needed. -Subbu From: Felix Cheung Sent: Thursday, December 27, 2018 12:12 PM To: dev@pinot.apache.org; g.kish...@gmail.com Subject: Re: Podling Report Reminder - January 2019 Another reminder since we are less than one week away from the deadline. From: Felix Cheung Sent: Friday, December 21, 2018 8:07 PM To: dev@pinot.apache.org; g.kish...@gmail.com Subject: Re: Podling Report Reminder - January 2019 Hi - quick reminder please see below. Report is due Wed January 02 -- Podling reports due by end of day Best to kick off discussions soon. Happy holidays! From: jmcl...@apache.org Sent: Friday, December 21, 2018 4:47 PM To: d...@pinot.incubator.apache.org Subject: Podling Report Reminder - January 2019 Dear podling, This email was sent by an automated system on behalf of the Apache Incubator PMC. It is an initial reminder to give you plenty of time to prepare your quarterly board report. The board meeting is scheduled for Wed, 16 January 2019, 10:30 am PDT. The report for your podling will form a part of the Incubator PMC report. The Incubator PMC requires your report to be submitted 2 weeks before the board meeting, to allow sufficient time for review and submission (Wed, January 02). Please submit your report with sufficient time to allow the Incubator PMC, and subsequently board members to review and digest. Again, the very latest you should submit your report is 2 weeks prior to the board meeting. Candidate names should not be made public before people are actually elected, so please do not include the names of potential committers or PPMC members in your report. Thanks, The Apache Incubator PMC Submitting your Report -- Your report should contain the following: * Your project name * A brief description of your project, which assumes no knowledge of the project or necessarily of its field * A list of the three most important issues to address in the move towards graduation. * Any issues that the Incubator PMC or ASF Board might wish/need to be aware of * How has the community developed since the last report * How has the project developed since the last report. * How does the podling rate their own maturity. This should be appended to the Incubator Wiki page at: https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.apache.org%2Fincubator%2FJanuary2019data=02%7C01%7Cssubramaniam%40linkedin.com%7Ca2b9d6cfe47549a9b8c308d66d34bc9d%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636816470609535863sdata=hevGA0h5ELNarNPTXRLvMOh7f2aplGcnTA2dVlwfyQo%3Dreserved=0 Note: This is manually populated. You may need to wait a little before this page is created from a template. Mentors --- Mentors should review reports for their project(s) and sign them off on the Incubator wiki page. Signing off reports shows that you are following the project - projects that are not signed may raise alarms for the Incubator PMC. Incubator PMC - To unsubscribe, e-mail: dev-unsubscr...@pinot.apache.org For additional commands, e-mail: dev-h...@pinot.apache.org
[GitHub] snleee closed pull request #4: updating trademark
snleee closed pull request #4: updating trademark URL: https://github.com/apache/incubator-pinot-site/pull/4 This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services - To unsubscribe, e-mail: dev-unsubscr...@pinot.apache.org For additional commands, e-mail: dev-h...@pinot.apache.org