Trying to run the QueryRunner class with following...
# troubleshootinga
abhinav wagle
03/31/2022, 10:28 PMTrying to run the QueryRunner class with following command, and am seeing.
Copy code
java -jar pinot-tool-launcher-jar-with-dependencies.jar QueryRunner -mode singleThread -queryFile test.q -numTimesToRunQueries 0 -numIntervalsToReportAndClearStatistics 5 -brokerHost <host-name>abhinav wagle
03/31/2022, 10:29 PM Copy code
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
ERROR StatusLogger Unrecognized format specifier [d]
ERROR StatusLogger Unrecognized conversion specifier [d] starting at position 16 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [thread]
ERROR StatusLogger Unrecognized conversion specifier [thread] starting at position 25 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [level]
ERROR StatusLogger Unrecognized conversion specifier [level] starting at position 35 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [logger]
ERROR StatusLogger Unrecognized conversion specifier [logger] starting at position 47 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [msg]
ERROR StatusLogger Unrecognized conversion specifier [msg] starting at position 54 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [n]
ERROR StatusLogger Unrecognized conversion specifier [n] starting at position 56 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [d]
ERROR StatusLogger Unrecognized conversion specifier [d] starting at position 16 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [thread]
ERROR StatusLogger Unrecognized conversion specifier [thread] starting at position 25 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [level]
ERROR StatusLogger Unrecognized conversion specifier [level] starting at position 35 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [logger]
ERROR StatusLogger Unrecognized conversion specifier [logger] starting at position 47 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [msg]
ERROR StatusLogger Unrecognized conversion specifier [msg] starting at position 54 in conversion pattern.
ERROR StatusLogger Unrecognized format specifier [n]
ERROR StatusLogger Unrecognized conversion specifier [n] starting at position 56 in conversion pattern.
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.codehaus.groovy.reflection.CachedClass (file:/Users/awagle/DataPlatform/pinot/pinot-tools/target/pinot-tool-launcher-jar-with-dependencies.jar) to method java.lang.Object.finalize()
WARNING: Please consider reporting this to the maintainers of org.codehaus.groovy.reflection.CachedClass
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
%d [%thread] %-5level %logger - %msg%nUsage: QueryRunnerabhinav wagle
03/31/2022, 10:29 PMIs there a doc available on how to use QueryRunner
abhinav wagle
03/31/2022, 11:00 PMAm I doing something wrong by providing BrokerHost
abhinav wagle
03/31/2022, 11:04 PMtest.q
Copy code
select * from airlineStatsm
Mayank
04/01/2022, 2:28 AM
I think there is query-runner.sh also built, can you try that?
a
abhinav wagle
04/01/2022, 2:54 AMThanks @User: Can you point me to the git link for it. I tried searching
m
Mayank
04/01/2022, 2:55 AM
You can build it via
mvn installa
abhinav wagle
04/01/2022, 10:34 PMHi @User. Thanks for your reply. Tried to build locally for some reason the shell script is not generated for me. Maybe I missing something. Any steps on documentation/readme?
m
Mayank
04/01/2022, 10:37 PM
Are you trying master?
a
abhinav wagle
04/01/2022, 10:39 PMyes. tried master
abhinav wagle
04/01/2022, 10:40 PMI even looked at downloading 0.10.0 directly using : https://docs.pinot.apache.org/basics/getting-started/running-pinot-locally
abhinav wagle
04/01/2022, 10:41 PMthis is what I see in /bin directory :
m
Mayank
04/02/2022, 1:08 AM
Copy code
find . -name 'query*sh'
./pinot-tools/target/pinot-tools-pkg/bin/query-runner.sh
./pinot-tools/target/pinot-tools-pkg/bin/query-comparator.sh
./kubernetes/skaffold/gke/query-pinot-data.sh
./kubernetes/helm/pinot/query-pinot-data.sh👍 1
a
abhinav wagle
04/04/2022, 4:24 PMThanks was looking at wrong place !