Title
a
Amy Wang
09/02/2022, 5:58 PMIf I understand your comment correctly - you will need to use the specific ID generated by your
COPYSELECT * FROM 'sys.text_import_log';s
Sam Shiles
09/02/2022, 8:21 PMHi Amy, I'll double check but I'm pretty sure I couldn't see that table at all
b
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 AMHI @Bolek Ziobrowski I'm currently on 6.4.2
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]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
I guess the answer is that that table exists in the newer version
a
Amy Wang
09/05/2022, 12:52 PMThis 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.1s
Sam Shiles
09/05/2022, 6:35 PMThanks 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.