And also we have Cassandra 4.0.5. [cqlsh 6.0.0 | Cassandra 4.0.5 | CQL spec 3.4.5 | Native protocol v5]
Is this FQL & fqltool dump - will work on 4.0.x also right ? > On Aug 9, 2023, at 9:18 AM, Akshith Mull <akshith.m...@gmail.com> wrote: > > > These are the class path settings , do we need to add anything here or is it > wrongly set? > Any solution to fix this will be greatly appreciated, > > cat /usr/bin/fqltool | grep CLASSPATH > if [ -z "$CASSANDRA_CONF" -o -z "$CLASSPATH" ]; then > echo "You must set the CASSANDRA_CONF and CLASSPATH vars" >&2 > "$JAVA" $JAVA_AGENT -ea -da:net.openhft... -cp "$CLASSPATH" $JVM_OPTS > -Xmx$MAX_HEAP_SIZE \ > > > > >> On Aug 8, 2023, at 12:57 PM, Miklosovic, Stefan >> <stefan.mikloso...@netapp.com> wrote: >> >> Hey, >> >> I did same steps from extracted tarball of 4.1.3 and it just works. It also >> works when I install Debian package. >> >> The error you get seems like the class path is not set correctly so it can >> not load it. >> >> You can probably debug this by wrapping last line in fqltool in "echo" to >> see what is on the class path. >> >> Regards >> >> ________________________________________ >> From: Akshith Mull <akshith.m...@gmail.com> >> Sent: Tuesday, August 8, 2023 18:30 >> To: user@cassandra.apache.org >> Subject: Cassandra FQL question- >> >> You don't often get email from akshith.m...@gmail.com. Learn why this is >> important<https://aka.ms/LearnAboutSenderIdentification> >> NetApp Security WARNING: This is an external email. Do not click links or >> open attachments unless you recognize the sender and know the content is >> safe. >> >> >> >> Hi All, >> >> We have cassandra 4.x version, >> >> I have enabled FQL as per the documentation- >> >> <https://cassandra.apache.org/doc/latest/cassandra/operating/fqllogging.html> >> Full Query Logging | Apache Cassandra >> Documentation<https://cassandra.apache.org/doc/latest/cassandra/operating/fqllogging.html> >> cassandra.apache.org<https://cassandra.apache.org/doc/latest/cassandra/operating/fqllogging.html> >> [favicon.ico]<https://cassandra.apache.org/doc/latest/cassandra/operating/fqllogging.html> >> >> >> nodetool enablefullquerylog --path /tmp/cassandrafullquerylog >> >> >> >> Files generated. >> >> >> -rw-r--r-- 1 131072 Aug 8 16:22 metadata.cq4t >> >> -rw-r--r-- 1 83886080 Aug 8 16:22 20230808-16.cq4 >> >> >> Its generated in binary . >> >> >> As per the doc Im running dump command to convert human readable format. >> >> >> fqltool dump /tmp/cassandrafullquerylog >> >> >> But Im getting below error. >> >> >> Error: Could not find or load main class >> org.apache.cassandra.fqltool.FullQueryLogTool >> >> Caused by: java.lang.ClassNotFoundException: >> org.apache.cassandra.fqltool.FullQueryLogTool >> >> >> Do we need to install anything to generate the output ? >> >> >> >> Gently appreciate the answers. >> >> >> >> thanks >> >> >> >> >> >> >> >