I am looking for some guidance on something: We are trying to add a 'week' integer parameter to TimestampFormatUtils compute method. We tried to add it and also add the corresponding 'I' on this line of code https://github.com/questdb/questdb/blob/a7aaa464fba30e9ecc044ce63e62db517bfc5609/core/src/main/java/io/questdb/std/datetime/microtime/TimestampFormatCompiler.java#L1522 but we are getting an error:

java.lang.reflect.InvocationTargetException
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.std.Unsafe$UnsafeClassDefiner.define(Unsafe.java:337)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.std.Unsafe.defineAnonymousClass(Unsafe.java:285)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.std.BytecodeAssembler.loadClass(BytecodeAssembler.java:418)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.std.BytecodeAssembler.newInstance(BytecodeAssembler.java:434)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.std.datetime.microtime.TimestampFormatCompiler.compile(TimestampFormatCompiler.java:1679)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.std.datetime.microtime.TimestampFormatCompiler.compile(TimestampFormatCompiler.java:245)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.std.datetime.microtime.TimestampFormatCompiler.compile(TimestampFormatCompiler.java:205)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.std.datetime.microtime.TimestampFormatCompiler.compile(TimestampFormatCompiler.java:201)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.std.datetime.microtime.TimestampFormatUtils.<clinit>(TimestampFormatUtils.java:407)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.cairo.PartitionByTest.assertFormatAndParse(PartitionByTest.java:374)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.cairo.PartitionByTest.testDirectoryFormattingWeek(PartitionByTest.java:194)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    ...
Caused by: java.lang.VerifyError: Bad type on operand stack
Exception Details:
  Location:
    io/questdb/std/datetime/TimestampFormatAsm.parse(Ljava/lang/CharSequence;IILio/questdb/std/datetime/DateLocale;)J @420: invokestatic
  Reason:
    Type 'io/questdb/std/datetime/DateLocale' (current frame, stack[0]) is not assignable to integer
  Current Frame:
    bci: @420
    flags: { }
    locals: { 'io/questdb/std/datetime/TimestampFormatAsm', 'java/lang/CharSequence', integer, integer, 'io/questdb/std/datetime/DateLocale', integer, integer, integer, integer, integer, integer, integer, integer, long, long_2nd, integer, long, long_2nd, integer, integer, integer }
    stack: { 'io/questdb/std/datetime/DateLocale', integer, integer, integer, integer, integer, integer, integer, integer, integer, integer, long, long_2nd, integer }
  Bytecode:
    0000000: 0336 0b1c 360c 0236 0f14 0011 3710 0536
    0000010: 1204 3613 0336 1419 042b 150c 1db6 001a
    0000020: 370d 150c 160d b800 3f60 360c 102c 2b15
    0000030: 0c84 0c01 1db8 0057 1020 2b15 0c84 0c01
    0000040: 1db8 0057 2b15 0c1d b800 3837 0d16 0db8
    0000050: 0042 3605 150c 160d b800 3f60 360c 1020
    0000060: 2b15 0c84 0c01 1db8 0057 1904 2b15 0c1d
    0000070: b600 1d37 0d16 0db8 0042 0460 3606 150c
    0000080: 160d b800 3f60 360c 1020 2b15 0c84 0c01
    0000090: 1db8 0057 150c 1da2 002b 2b15 0cb9 00ca
    00000a0: 0200 102d a000 1e15 0c07 601d b800 4c2b
    00000b0: 150c 0460 840c 0515 0cb8 0046 7436 07a7
    00000c0: 0018 150c 0660 1db8 004c 2b15 0c84 0c04
    00000d0: 150c b800 4636 0710 202b 150c 840c 011d
    00000e0: b800 5715 0c04 601d b800 4c2b 150c 840c
    00000f0: 0215 0cb8 0046 3608 103a 2b15 0c84 0c01
    0000100: 1db8 0057 150c 0460 1db8 004c 2b15 0c84
    0000110: 0c02 150c b800 4636 0910 3a2b 150c 840c
    0000120: 011d b800 5715 0c04 601d b800 4c2b 150c
    0000130: 840c 0215 0cb8 0046 360a 1020 2b15 0c84
    0000140: 0c01 1db8 0057 2b15 0c1d b800 8d37 0d16
    0000150: 0d14 0011 949a 0018 1904 2b15 0c1d b600
    0000160: 2037 0d16 0db8 0042 360f a700 1016 0db8
    0000170: 0042 0085 1400 1369 3710 150c 160d b800
    0000180: 3f60 360c 150c 1db8 004f 1904 1513 1507
    0000190: 1506 1505 1508 1509 150a 150b 1514 150f
    00001a0: 1610 1512 b800 5bad                    
  Stackmap Table:
    full_frame(@194,{Object[#9],Object[#16],Integer,Integer,Object[#14],Integer,Integer,Top,Top,Top,Top,Integer,Integer,Long,Integer,Long,Integer,Integer,Integer},{})
    full_frame(@215,{Object[#9],Object[#16],Integer,Integer,Object[#14],Integer,Integer,Integer,Top,Top,Top,Integer,Integer,Long,Integer,Long,Integer,Integer,Integer},{})
    full_frame(@365,{Object[#9],Object[#16],Integer,Integer,Object[#14],Integer,Integer,Integer,Integer,Integer,Integer,Integer,Integer,Long,Integer,Long,Integer,Integer,Integer},{})
    same_frame(@378)
    at java.base/jdk.internal.misc.Unsafe.defineAnonymousClass0(Native Method)
    at java.base/jdk.internal.misc.Unsafe.defineAnonymousClass(Unsafe.java:1223)
    at jdk.unsupported/sun.misc.Unsafe.defineAnonymousClass(Unsafe.java:830)
    ... 43 more
java.lang.AssertionError
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.std.BytecodeAssembler.newInstance(BytecodeAssembler.java:435)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.std.datetime.microtime.TimestampFormatCompiler.compile(TimestampFormatCompiler.java:1679)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.std.datetime.microtime.TimestampFormatCompiler.compile(TimestampFormatCompiler.java:245)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.std.datetime.microtime.TimestampFormatCompiler.compile(TimestampFormatCompiler.java:205)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.std.datetime.microtime.TimestampFormatCompiler.compile(TimestampFormatCompiler.java:201)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.std.datetime.microtime.TimestampFormatUtils.<clinit>(TimestampFormatUtils.java:407)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.cairo.PartitionByTest.assertFormatAndParse(PartitionByTest.java:374)
    at io.questdb@6.5.3-SNAPSHOT/io.questdb.cairo.PartitionByTest.testDirectoryFormattingWeek(PartitionByTest.java:194)
...

Wondering if we missed any steps required to add a parameter to this method?

Hi, I am working on this issue. The ILIKE operator is not working as expected

Hey everyone, just opened a small doc PR (my first here) #2597. Looking to utilise the Hacktoberfest month to get involved in the community. Let me know if there is anything specific that anybody would like to me work on. Looking for a steep learning curve in Java as well as Database Internals!

Hi everyone, I am working on this issue #2578 (Hacktoberfest 2022). I was working on the ceiling function, in Numeric section. I've hit a roadblock can't understand the following error. Can someone guide me, what I am missing?

Hi guys, i created some issues about window function row_number #2611 #2620 ， can anyone confirm these？

I was wondering what the desired solution to this issue would be: https://github.com/questdb/questdb/issues/2584 I think there are a few things we could do, but I'm not sure which to pursue.

Hi guys, i am working on this issue #2611, but i can't find a method to test it. can somebody tell me how to test window function ?

Hi guys, i have a question about

support trunc on mac addresses for IoT use cases

task which in issue #2578: we don't have

MacAddress

data type, so what the entry data type of

trunc

function use?

That's a good question. Since MAC address requires 6 bytes, that could be

long

or, maybe,

string

. Both are not ideal though

Maybe we need to add the

MacAddress

data type first？

Adding a new data type is complicated. Certainly possible, but the code would need to be changed in lots of places

Hi @龚磊 thanks a lot for the question, and thanks @Andrey Pechkurov for helping on this. In that case this might not be the best contribution idea at the moment, let me remove it for now. 🙂

Does anyone have any advice (at a high level) for the simplest way to loop through the documents in a directory (for the purpose of reading their meta data) using QuestDB utils? Or would this best be done with regular java libraries?

Hello, I want to contribute and I’m trying to build this locally. Is there a way to build it with intelliJ? If not, where do I run

mvn clean package -DskipTests -P build-web-console

?

also wanted to ask, is someone working on this https://github.com/questdb/questdb/issues/2623? already? most of the issues here seem to be done already? https://github.com/questdb/questdb/issues/2578. What is a good first issue then

I am using intelliJ for develop, you can follow this:

Hello, I am working on implementing some of the row functions listed in https://github.com/questdb/questdb/issues/2578 and was wondering what exactly "eth_value" is supposed to be. Is it a typo of nth_value as in postgres?

I’m following this page: https://github.com/questdb/questdb/blob/master/core/README.md and when I try to run this locally, I can’t find/load module. can some one help me understand if I missed something please?

jenny.lian@JLian-M-RX7DW questdb % java -jar core/target/questdb-6.5.4-SNAPSHOT-tests.jar -d jen_db_root
Error: Could not find or load main class io.questdb.ServerMain
Caused by: java.lang.ClassNotFoundException: io.questdb.ServerMain

can someone teach me how to just run one unit test in intelliJ please? For example I’m looking at a past PR for this file

core/src/test/java/io/questdb/griffin/engine/functions/math/WidthBucketFunctionFactoryTest.java

How do I just run this test?

I have some questions about the AnalyticFunction interface and its intended use. Apologies if this is not the correct place to ask this. • It looks like implementations of AnalyticFunction are meant to use their "pass2" methods for row functions that require aggregating over all elements of a partition before writing values to rows, such as stddev (currently unimplemented, although I would like to work on it next). However, the two implementations of this interface do not currently need a second pass, and neither will the function I am currently working on (dense_rank) which results in several implemented but empty methods in all AnalyticFunction implementations. Should 1pass, 2pass, etc functions each have their own interface? It would make the code somewhat easier to understand. Related to this, shouldn't all trivially implemented and not used methods throw an UnsupportedOperationException? Currently only getLong does (for the AnalyticFunctions, anyway) • I read in the contribution guide that usage of "new" is discouraged so as to avoid garbage collection. Do the uses of "new" to create Function objects in the analytic function files need to be changed? • Given that the rank() function caused a bug on M1 CPUs (which I unfortunately do not have access to) should I postpone my work on the dense_rank() function? I have patterned it off of the row_number() function to avoid whatever bug rank() has but I am very new to how Java's Unsafe logic works and how QuestDB uses it. I would not want to reintroduce a bug, nor create extra work for the reviewer if it is a known problem with the general way analytic functions are set up. Thanks in advance. Edit: Also, is there a standard way your team sets up debugging with IntelliJ (or any other application)? I am a C#/SQL programmer primarily so not as used to the java ecosystem. Thank you again.

I was reading this issue https://github.com/questdb/questdb/issues/353 and I verified this is sorted, but I can’t explain why… can some one help me please understand why this is sorted? Seems like there’s this method called doQueryRecordLoop, I’m not sure what is

columnCount

but some how all the records are in alphabetical order and it’s wrtten directly into the socket… can some one give me a overview please?

RE:https://github.com/questdb/questdb/issues/2623, I think the fix is to not use the \\ at all..the explaination said \\ the first \ is trying to match the next one. Is that right?

Hi @Vlad, thanks for the review

Is there a function to get the name of a file given its long filePointer (pUtf8NameZ)? Specifically for use in fileFacade.iterateDir()

Hello all. I had been working on issue #2509 and have raised PR #2768 that should address the issue. Someone please review it. Thank you.

Hi, I have addressed issue https://github.com/questdb/questdb/issues/2509 (prev PR stale) in https://github.com/questdb/questdb/pull/2943 please take a look. Thanks

Hi folks, I am currently working on https://github.com/questdb/questdb/issues/2794. As far as I can see, the PG Wire metrics should be exposed from

PGWireMetrics.java

just as

JsonQueryMetrics.java

does for JSON query metrics. I wanted to get some clues where to start, is there a test that I can run to see what existing Prometheus metrics has been exposed?

Hi all, I am trying to build and run local quest db (source code checked out) and see prometheus metrics. Here are what I've done 1. Checkout to local computer 2. Un-comment

metrics.enabled=true

in

core/src/main/resources/io/questdb/site/conf/server.conf

to allow the feature 3. Build by

mvn clean package --batch-mode --quiet -DskipTests -P build-web-console,build-binaries

4. Run by

java -p core/target/questdb-6.7.1-SNAPSHOT.jar -m io.questdb/io.questdb.ServerMain -d ~/database_questdb

However, in the log, it still says below on the log

Metrics are disabled, health check endpoint will not consider unhandled errors

and localhost:9003 only sees

Status: Healthy

. Is there anything I am missing?