Saoirse Amarteifio
09/11/2021, 1:58 PMSlackbot
09/14/2021, 8:34 AMDan DC
09/14/2021, 3:41 PMRZ
09/16/2021, 10:44 AMTiger Zhao
09/16/2021, 6:22 PMxtrntr
09/21/2021, 6:05 AMdimTable
but not factTable
to filter in the WHERE clause?
https://docs.google.com/document/d/1InWmxbRqwcqIakzvoEWHLxtX4XR9H5L01256EbAUHV8/edit#
Table factTable:
string uuid
int metric
timestamp event_time
string status
Table dimTable:
string uuid
string name
string country
SELECT
f.uuid,
d.name,
d.country,
abs(sum(m.metric)) as sum_metric
FROM
factTable f join dimTable d on f.uuid = d.uuid
WHERE
d.country in ('USA')
GROUP BY
1,
2,
3
ORDER BY
2
arun muralidharan
09/21/2021, 3:47 PMTiger Zhao
09/22/2021, 9:14 PMwith
clause, or views?Tiger Zhao
10/01/2021, 8:20 PMDan DC
10/07/2021, 2:50 PMNeha Pawar
Saoirse Amarteifio
10/11/2021, 5:12 PMRecordReader initialized will read a total of 8 records.
at row 0. reading next block
block read in memory in 1 ms. row count = 8
Start building IndexCreator!
Finished records indexing in IndexCreator!
Failed to generate Pinot segment for file - <s3://bucket/samples/data/myData/test.parquet>
java.lang.IllegalArgumentException: null
at shaded.com.google.common.base.Preconditions.checkArgument(Preconditions.java:108) ~[pinot-all-0.9.0-SNAPSHOT-jar-with-dependencies.jar:0.9.0-SNAPSHOT-11f8550b9b2881ede4d105416ed970a5dd708463]
at org.apache.pinot.segment.spi.creator.name.SimpleSegmentNameGenerator.generateSegmentName(SimpleSegmentNameGenerator.java:53) ~[pinot-all-0.9.0-SNAPSHOT-jar-with-dependencies.jar:0.9.0-SNAPSHOT-11f8550b9b2881ede
4d105416ed970a5dd708463]
Can anyone suggest what illegal thing i am doing from this error message? adding jobSpec in thread...Saoirse Amarteifio
10/11/2021, 8:43 PMtimestamp
even though the spec for presto suggests that it can be escaped with double quotes, i cannot seem to submit a query that includes "timestamp"
It might be specific to the clients I am using; i have tried the presto-cli freshly downloaded and a python client and both result in a PQLParsingError. What to do in this situation? (this is testing the presto-pinot connector but maybe not a Pinot question for this channel)Sharon Akinyi
10/13/2021, 8:18 AMCourage Noko
10/13/2021, 7:56 PMpinot.controller.storage.factory.gs.projectId
on the server/controller during deployment or update these?Neha Pawar
Priyank Bagrecha
11/02/2021, 6:25 PMPriyank Bagrecha
11/02/2021, 10:34 PMtyler dobbs
11/03/2021, 4:54 AM0.8.0
and openjdk:11
. I'm on a mac. I'm trying to start the cluster by using the pinot admin commands StartZookeeper
StartController
StartBroker
and StartServer
as shown in the getting started. However inevitably the controller will go down before I can start the Broker and the Server with this error: Expiring session 0x100080c84b20005, timeout of 30000ms exceeded
, Is there a way to avoid this?Priyank Bagrecha
11/09/2021, 12:56 AMenableDefaultStarTree
and enableDynamicStarTreeCreation
fields in the table confi? I want to understand what does a default / dynamic star-tree index mean.Priyank Bagrecha
11/09/2021, 9:56 PMPriyank Bagrecha
11/11/2021, 9:11 PMOptimizing Scatter and Gather
is broken on https://docs.pinot.apache.org/operators/operating-pinot/tuningNeha Pawar
Priyank Bagrecha
11/15/2021, 9:40 PMTransform Function in Aggregation Grouping
is broken on https://docs.pinot.apache.org/users/user-guide-query/querying-pinot#udf. I am guessing it should be pointing to https://docs.pinot.apache.org/users/user-guide-query/supported-transformations.xtrntr
11/16/2021, 6:09 AMIdSet
with “NOT IN” clause have any unintended performance impact?
e.g. select * from table where userid not in IDSET(...)
Priyank Bagrecha
11/18/2021, 9:02 AMPriyank Bagrecha
11/19/2021, 7:25 AMDiana Arnos
11/19/2021, 2:10 PMstream.kafka.decoder.prop.schema.registry.rest.url
and stream.kafka.decoder.prop.schema.registry.schema.name
could help me achieve this.Pavel Stejskal
11/29/2021, 7:29 PMLuis Fernandez
12/01/2021, 7:27 PM