# general
- k
Kishore G
04/03/2020, 4:59 PMI dint know Amazon Athena would allow installing your own connector - d
Dan Hill
04/03/2020, 5:08 PMI don't know much about Athena. There's a way of installing connectors using AWS Lambda. - k
Kishore G
04/03/2020, 5:11 PMlooks like they do - https://github.com/awslabs/aws-athena-query-federation/wiki/Available-Connectors - d
Dan Hill
04/03/2020, 5:13 PM - d
Dan Hill
04/03/2020, 5:13 PMYea - d
Dan Hill
04/03/2020, 5:14 PMThis isn't a blocker for my team. Mostly was curious. For my use case, the price would work out well. - h
Harshini Elath
04/03/2020, 7:27 PMhow does pagination work in pinot queries ? - h
Harshini Elath
04/03/2020, 7:28 PMSELECT foo, bar FROM myTable WHERE baz > 20 ORDER BY bar DESC LIMIT 50, 100 - h
Harshini Elath
04/03/2020, 7:28 PMis 50 offset and 100 limit ? - h
Harshini Elath
04/03/2020, 7:29 PMit is giving the correct number of records but it looks like offset always starting from first record in results - x
Xiang Fu
04/03/2020, 9:28 PMLIMIT 50, 100 should return results from doc id 50-149 - x
Xiang Fu
04/03/2020, 9:29 PMjust if you don’t order by foo/bar, then your results may not be consistent between two queries - m
Mayank
04/03/2020, 9:29 PMIt does end up redoing the entire query again though, and in case if ties you may see the same overlapping records - h
Harshini Elath
04/03/2020, 9:29 PMselect psa_cd, psa_name, item_id, item_name,sum(net_purchases), sum(cash_purchases), sum(write_off_sales), sum(transfers), sum(net_merchandise_sales) from iw_trans_inventory where str_num = 39087 and transaction_date >= '2019-10-25' and transaction_date <'2020-01-09' and item_id != -99999 and sale_type = 'Original Retail' group by psa_cd, psa_name, item_id, item_name order by psa_cd, psa_name, item_id, item_name LIMIT 500,500 - h
Harshini Elath
04/03/2020, 9:30 PMthis was the sample query - m
Mayank
04/03/2020, 9:30 PMLimit with offset is only for selection queries at the moment - m
Mayank
04/03/2020, 9:30 PMYour query is aggr group by - h
Harshini Elath
04/03/2020, 9:30 PMOh okay 👍 - d
Dan Hill
04/04/2020, 4:28 AMIs there a Helm chart for
? I tried to modify an existing Helm chart for other presto images but I'm hitting issuesapachepinot/pinot-presto:latest
. I'm guessing this Docker image is different from other Presto Docker images.Error: failed to start container "presto-coordinator": Error response from daemon: OCI runtime create failed: container_linux.go:345: starting container process caused "exec: \"python3\": executable file not found in $PATH": unknown - x
Xiang Fu
04/04/2020, 4:33 AMso you are using
?apachepinot/pinot-presto:latest - d
Dan Hill
04/04/2020, 4:34 AMYea - x
Xiang Fu
04/04/2020, 4:35 AMcan you try this image :apachepinot/pinot-presto:0.234.1 - x
Xiang Fu
04/04/2020, 4:35 AMthis image should have python installed already - x
Xiang Fu
04/04/2020, 4:35 AMdid you change PATH in the image - x
Xiang Fu
04/04/2020, 4:35 AMor the env variable ? - d
Dan Hill
04/04/2020, 4:36 AMI can try that. I don't know. I used the helm chart at
and I changed the repository and ripped out two of the values that were not used.<https://github.com/wiwdata/presto-chart> - d
Dan Hill
04/04/2020, 4:38 AMI get the same issue with
. I can try a different helm chart next.0.234.1 - x
Xiang Fu
04/04/2020, 4:38 AMyes - d
Dan Hill
04/04/2020, 4:38 AM<https://github.com/helm/charts/tree/master/stable/presto> - x
Xiang Fu
04/04/2020, 4:38 AMor you can try out kube yaml file