KX Community

Find answers, ask questions, and connect with our KX Community around the world.
KX Community Guidelines

Home Forums kdb+ Trying to run ArrowKDB Examples from doc

  • Trying to run ArrowKDB Examples from doc

    Posted by liordra on November 13, 2023 at 12:00 am

    Hi,

    I am using KDB (KDB+ 4.0 Cloud Edition)

    I have downloaded and installed arrowkdb-linux-1.4.0-rc.1.tgz

    My OS is Ubuntu 22.04.

    I have been trying to run the examples  but I can’t get it to work.

    my error is:

    q))N:5 
    q))table:([]tstamp:asc N?0p;temperature:N?100f;fill_level:N?100;pump_status:N?0b;comment:N?("start";"stop";"alert";"acknowledge";""))
    q))table
    tstamp temperature fill_level pump_status comment
    ------------------------------------------------------------------------
    2000.12.02D23:06:28.003159316 61.37452 84 1 "" 
    2001.11.18D19:43:09.227684584 52.94808 63 0 "start"
    2002.07.16D06:07:32.855097504 69.16099 93 0 "alert"
    2003.10.19D21:55:27.854490288 22.96615 54 1 "stop" 
    2003.11.14D03:17:50.306526128 69.19531 38 0 "alert"
    q)).arrowkdb.tb.prettyPrintTableFromTable[table;::]
    '.arrowkdb.tb.prettyPrintTableFromTable
    [5] .arrowkdb.tb.prettyPrintTableFromTable[table;::]
    ^

     

    I have searched the board and found this message

    so in order to save time I am attaching the result of

     

    ldd $QHOME/l64/arrowkdb.so
    linux-vdso.so.1 (0x00007ffc28950000)
    libarrow.so.900 => /lib/x86_64-linux-gnu/libarrow.so.900 (0x00007fc45b812000)
    libparquet.so.900 => /lib/x86_64-linux-gnu/libparquet.so.900 (0x00007fc45b4e0000)
    libstdc++.so.6 => /lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007fc45b2fe000)
    libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007fc45b2e3000)
    libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fc45b0f1000)
    libbrotlienc.so.1 => /lib/x86_64-linux-gnu/libbrotlienc.so.1 (0x00007fc45b068000)
    libbrotlidec.so.1 => /lib/x86_64-linux-gnu/libbrotlidec.so.1 (0x00007fc45b058000)
    libutf8proc.so.2 => /lib/x86_64-linux-gnu/libutf8proc.so.2 (0x00007fc45b00b000)
    libre2.so.5 => /lib/x86_64-linux-gnu/libre2.so.5 (0x00007fc45af9a000)
    libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007fc45af94000)
    libcrypto.so.1.1 => /lib/x86_64-linux-gnu/libcrypto.so.1.1 (0x00007fc45acbe000)
    libbz2.so.1.0 => /lib/x86_64-linux-gnu/libbz2.so.1.0 (0x00007fc45acab000)
    liblz4.so.1 => /lib/x86_64-linux-gnu/liblz4.so.1 (0x00007fc45ac88000)
    libsnappy.so.1 => /lib/x86_64-linux-gnu/libsnappy.so.1 (0x00007fc45ac7d000)
    libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007fc45ac61000)
    libzstd.so.1 => /lib/x86_64-linux-gnu/libzstd.so.1 (0x00007fc45abb8000)
    libcurl.so.4 => /lib/x86_64-linux-gnu/libcurl.so.4 (0x00007fc45ab25000)
    libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007fc45a9d6000)
    libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007fc45a9b1000)
    /lib64/ld-linux-x86-64.so.2 (0x00007fc45dc1d000)
    libthrift-0.13.0.so => /lib/x86_64-linux-gnu/libthrift-0.13.0.so (0x00007fc45a8fa000)
    libbrotlicommon.so.1 => /lib/x86_64-linux-gnu/libbrotlicommon.so.1 (0x00007fc45a8d7000)
    libnghttp2.so.14 => /lib/x86_64-linux-gnu/libnghttp2.so.14 (0x00007fc45a8ae000)
    libidn2.so.0 => /lib/x86_64-linux-gnu/libidn2.so.0 (0x00007fc45a88d000)
    librtmp.so.1 => /lib/x86_64-linux-gnu/librtmp.so.1 (0x00007fc45a86b000)
    libssh.so.4 => /lib/x86_64-linux-gnu/libssh.so.4 (0x00007fc45a7fd000)
    libpsl.so.5 => /lib/x86_64-linux-gnu/libpsl.so.5 (0x00007fc45a7ea000)
    libssl.so.1.1 => /lib/x86_64-linux-gnu/libssl.so.1.1 (0x00007fc45a757000)
    libgssapi_krb5.so.2 => /lib/x86_64-linux-gnu/libgssapi_krb5.so.2 (0x00007fc45a70a000)
    libldap_r-2.4.so.2 => /lib/x86_64-linux-gnu/libldap_r-2.4.so.2 (0x00007fc45a6b4000)
    liblber-2.4.so.2 => /lib/x86_64-linux-gnu/liblber-2.4.so.2 (0x00007fc45a6a1000)
    libunistring.so.2 => /lib/x86_64-linux-gnu/libunistring.so.2 (0x00007fc45a51f000)
    libgnutls.so.30 => /lib/x86_64-linux-gnu/libgnutls.so.30 (0x00007fc45a349000)
    libhogweed.so.5 => /lib/x86_64-linux-gnu/libhogweed.so.5 (0x00007fc45a312000)
    libnettle.so.7 => /lib/x86_64-linux-gnu/libnettle.so.7 (0x00007fc45a2d8000)
    libgmp.so.10 => /lib/x86_64-linux-gnu/libgmp.so.10 (0x00007fc45a252000)
    libkrb5.so.3 => /lib/x86_64-linux-gnu/libkrb5.so.3 (0x00007fc45a175000)
    libk5crypto.so.3 => /lib/x86_64-linux-gnu/libk5crypto.so.3 (0x00007fc45a144000)
    libcom_err.so.2 => /lib/x86_64-linux-gnu/libcom_err.so.2 (0x00007fc45a13d000)
    libkrb5support.so.0 => /lib/x86_64-linux-gnu/libkrb5support.so.0 (0x00007fc45a12e000)
    libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007fc45a110000)
    libsasl2.so.2 => /lib/x86_64-linux-gnu/libsasl2.so.2 (0x00007fc45a0f3000)
    libgssapi.so.3 => /lib/x86_64-linux-gnu/libgssapi.so.3 (0x00007fc45a0ae000)
    libp11-kit.so.0 => /lib/x86_64-linux-gnu/libp11-kit.so.0 (0x00007fc459f78000)
    libtasn1.so.6 => /lib/x86_64-linux-gnu/libtasn1.so.6 (0x00007fc459f62000)
    libkeyutils.so.1 => /lib/x86_64-linux-gnu/libkeyutils.so.1 (0x00007fc459f59000)
    libheimntlm.so.0 => /lib/x86_64-linux-gnu/libheimntlm.so.0 (0x00007fc459f4d000)
    libkrb5.so.26 => /lib/x86_64-linux-gnu/libkrb5.so.26 (0x00007fc459eba000)
    libasn1.so.8 => /lib/x86_64-linux-gnu/libasn1.so.8 (0x00007fc459e14000)
    libhcrypto.so.4 => /lib/x86_64-linux-gnu/libhcrypto.so.4 (0x00007fc459ddc000)
    libroken.so.18 => /lib/x86_64-linux-gnu/libroken.so.18 (0x00007fc459dc1000)
    libffi.so.7 => /lib/x86_64-linux-gnu/libffi.so.7 (0x00007fc459db5000)
    libwind.so.0 => /lib/x86_64-linux-gnu/libwind.so.0 (0x00007fc459d8b000)
    libheimbase.so.1 => /lib/x86_64-linux-gnu/libheimbase.so.1 (0x00007fc459d79000)
    libhx509.so.5 => /lib/x86_64-linux-gnu/libhx509.so.5 (0x00007fc459d2b000)
    libsqlite3.so.0 => /lib/x86_64-linux-gnu/libsqlite3.so.0 (0x00007fc459c02000)
    libcrypt.so.1 => /lib/x86_64-linux-gnu/libcrypt.so.1 (0x00007fc459bc5000)

     

     

    Could you please advise?

     

    liordra replied 3 months ago 2 Members · 3 Replies
  • 3 Replies
  • rocuinneagain

    Member
    November 13, 2023 at 12:00 am

    You have tried to use the function .arrowkdb.tb.prettyPrintTableFromTable and received the error '.arrowkdb.tb.prettyPrintTableFromTable.

    In kdb this means the variable does not exist:

     

    q)doesNotExist[1] 'doesNotExist [0] doesNotExist[1]

     

    This suggests you have yet to load the library.

    Either pass it to the command line q arrowkdb.q or load it in your running session q)l arrowkdb.q

     

  • liordra

    Member
    November 13, 2023 at 12:00 am

    Correction: the OS version is actually:  Ubuntu 20.04.2 LTS.

  • liordra

    Member
    November 13, 2023 at 12:00 am

    Thank you very much!

Log in to reply.