Title
#users-public
Amy Wang

Amy Wang

09/02/2022, 5:58 PM
If I understand your comment correctly - you will need to use the specific ID generated by your
COPY
operation. Otherwise, you could select the whole table without using any ID:
SELECT * FROM 'sys.text_import_log';
By default all the record for the past 3 days should be there.
s

Sam Shiles

09/02/2022, 8:21 PM
Hi Amy, I'll double check but I'm pretty sure I couldn't see that table at all
Bolek Ziobrowski

Bolek Ziobrowski

09/05/2022, 6:42 AM
@Sam Shiles Are you running 6.5 or more recent version ? The table could use a different prefix if cairo.system.table.prefix was overriden .
s

Sam Shiles

09/05/2022, 11:42 AM
HI @Bolek Ziobrowski I'm currently on 6.4.2
11:43 AM
2022-09-05T11:42:37.846113Z I i.q.c.h.p.JsonQueryProcessorState [95] exec [q='SELECT * FROM 'sys.text_import_log';']
2022-09-05T11:42:37.846400Z I i.q.c.h.p.QueryCache miss [thread=questdb-worker-7, sql=SELECT * FROM 'sys.text_import_log';]
2022-09-05T11:42:37.847968Z I i.q.c.h.p.JsonQueryProcessorState [95] syntax-error [q=`SELECT * FROM 'sys.text_import_log';`, at=14, message=`table does not exist [name=sys.text_import_log]`]
2022-09-05T11:42:37.848439Z I i.q.c.h.p.JsonQueryProcessor all sent [fd=95, lastRequestBytesSent=326, nCompletedRequests=10, totalBytesSent=1717390]
11:45 AM
I thought I was on the latest version, to be honest, but I must have pulled my docker image from docker hub a while back and not updated it
11:46 AM
I guess the answer is that that table exists in the newer version
Amy Wang

Amy Wang

09/05/2022, 12:52 PM
This functionality is available from QuestDB 6.5 and our latest version is 6.5.1, although we’re planning to release 6.5.2 today. You can giet is bu using
docker run -v "$(pwd):/root/.questdb/conf" -p 4000:4000 questdb/questdb:6.5.1
I have talked to @Marius Gheorghies on our team to look into the volume mounting issue and once I understand the right path to use, I will work on updating the docs to capture the steps to upgrade version as described here.
s

Sam Shiles

09/05/2022, 6:35 PM
Thanks Amy, good stuff, I'll get onto the latest version. Thanks for the update on the mounting issue but it's not blocking me at all, was just for your info really.