the instruction says

# navigate to directory containing the setup scripts
cd pinot-distribution/target/apache-pinot-incubating-$PINOT_VERSION-bin/apache-pinot-incubating-$PINOT_VERSION-bin

yes you are right, i thought building from maven was pointing the target the the main /target folder...

oic

my wrong!

we will make the document to be more clear 🙂

no no i have to change my glasses

ahah

😛

ok so now i can change the source code an re-build it again

re-build and run the maven again to generate the targets

thank you @Xiang Fu!

exactly!

👍

However the previous mvn command to build everything took Total time: 09:10 min 😄 I hope to write everything correctly ahah

Do

datetrunc

and

dateTimeConv

have any known issues? When I run

select timestamp, sum(impressions) from events group by timestamp

I receive results (30 rows). When I execute the following queries, I get zero rows.

select DATETRUNC('day', timestamp) as date, sum(impressions) from events group by date

select dateTimeConvert(timestamp, '1:MILLISECONDS:EPOCH', '1:DAYS:SIMPLE_DATE_FORMAT:yyyyMMdd tz(America/Los_Angeles)', '1:DAYS') as date, sum(impressions) from events group by date

I hit these issues when trying to use in the Pinot Data Explorer directly. If I try to use them with Presto, I get

Function datetrunc not registered

and

Function datetimeconvert not registered

.

is timestamp name of the column?

did you escape that column name

Ah, I can try that

Escaping 'timestamp' didnt work.

what's the error after escaping "timestamp" on Pinot Data Explorer?

select dateTimeConvert('timestamp', '1:MILLISECONDS:EPOCH', '1:DAYS:SIMPLE_DATE_FORMAT:yyyyMMdd tz(America/Los_Angeles)', '1:DAYS') as mydate, sum(impressions) from events group by mydate

ProcessingException(errorCode: 450,
message: InternalError: <http://java.io|java.io>.IOException: Failed: HTTP error code: 500
at org.apache.pinot.controller.api.resources.PinotQueryResource.sendPostRaw(PinotQueryResource.java: 284)
at org.apache.pinot.controller.api.resources.PinotQueryResource.sendRequestRaw(PinotQueryResource.java: 322)
at org.apache.pinot.controller.api.resources.PinotQueryResource.getQueryResponse(PinotQueryResource.java: 204)
at org.apache.pinot.controller.api.resources.PinotQueryResource.handlePostSql(PinotQueryResource.java: 131)
at sun.reflect.GeneratedMethodAccessor87.invoke(Unknown Source)

java.lang.ClassCastException: java.util.HashMap cannot be cast to java.lang.Double
	at org.apache.pinot.core.query.aggregation.function.SumAggregationFunction.extractFinalResult(SumAggregationFunction.java:30) ~[pinot-all-0.3.0-SNAPSHOT-jar-with-dependencies.jar:0.3.0-SNAPSHOT-3cb4a25fbad543ed552443e8d884a489079dc003]
	at org.apache.pinot.core.query.reduce.GroupByDataTableReducer.setSQLGroupByInResultTable(GroupByDataTableReducer.java:211) ~[pinot-all-0.3.0-SNAPSHOT-jar-with-dependencies.jar:0.3.0-SNAPSHOT-3cb4a25fbad543ed552443e8d884a489079dc003]
	at org.apache.pinot.core.query.reduce.GroupByDataTableReducer.reduceAndSetResults(GroupByDataTableReducer.java:142) ~[pinot-all-0.3.0-SNAPSHOT-jar-with-dependencies.jar:0.3.0-SNAPSHOT-3cb4a25fbad543ed552443e8d884a489079dc003]
	at org.apache.pinot.core.query.reduce.BrokerReduceService.reduceOnDataTable(BrokerReduceService.java:186) ~[pinot-all-0.3.0-SNAPSHOT-jar-with-dependencies.jar:0.3.0-SNAPSHOT-3cb4a25fbad543ed552443e8d884a489079dc003]
	at org.apache.pinot.broker.requesthandler.SingleConnectionBrokerRequestHandler.processBrokerRequest(SingleConnectionBrokerRequestHandler.java:107) ~[pinot-all-0.3.0-SNAPSHOT-jar-with-dependencies.jar:0.3.0-SNAPSHOT-3cb4a25fbad543ed552443e8d884a489079dc003]
	at org.apache.pinot.broker.requesthandler.BaseBrokerRequestHandler.handleRequest(BaseBrokerRequestHandler.java:319) ~[pinot-all-0.3.0-SNAPSHOT-jar-with-dependencies.jar:0.3.0-SNAPSHOT-3cb4a25fbad543ed552443e8d884a489079dc003]
	at org.apache.pinot.broker.api.resources.PinotClientRequest.processSqlQueryPost(PinotClientRequest.java:146) ~[pinot-all-0.3.0-SNAPSHOT-jar-with-dependencies.jar:0.3.0-SNAPSHOT-3cb4a25fbad543ed552443e8d884a489079dc003]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_242]

Seems like a different error now

I turned off the "Query Syntax: PQL". I didn't know if I needed it with the time columns.

I'll be slow to reply again. I'm going to be away for an hour or so.

That value is a long in the schema.

are you using the pinot release, or do you have the latest code?

was this working fine before?

this works for me:

select dateTimeConvert("timestamp", '1:MILLISECONDS:EPOCH', '1:HOURS:EPOCH', '1:HOURS') as myDate, sum(score) from transcript group by myDate