Brand new user here, just playing around. I see that I can create tables with a specific structure.. however when I was playing with the python questdb.ingress I was using Sender() to send rows to a table which I had not yet created. Is the python questdb.ingress creating the table for me as it doesn't exist? And is it having a best effort guess at what data types to use for the symbols/columns? Is there a way I can be specific about the data types in the python sender.row()? Thanks 🙂

with Sender(host, port) as sender:

sender.row(

'price_test',

symbols={'store': '12345',

'product': 'Widget',

'prod_type': 'Item Only'},

columns={

'price': '6.75'

},

)

welcome @John! team will be looking into this

Thanks. Off topic: Listened to you on "The Craft Of Open Source" podcast from 4/5/2021 yesterday. 👍

nice, good to hear ! how did you find about the podcast?

I enjoyed it. Peaked my interest to have a play with questdb.

@John. Python client sends data to ILP endpoint which creates the missing tables/columns by guessing the type. While you can influence it with the following settings : • line.float.default.column.type • line.integer.default.column.type • line.default.partition.by It's often better to create table with exact types & settings in advance .

Thanks @Bolek Ziobrowski. If I send a row via ILP (Sender()) endpoint that does not conform to the table created, should Sender() be raising an IngressError exception?

The default behavior of ILP is to close connection on error . You should find error messages in qdb logs .

Yep, I see it. Thank you @Bolek Ziobrowski