Jack
Pei
Jack
Pei
Jack
Pei
venue
& type
strings or symbols?Jack
Pei
WHERE
on symbols in console with a small dataset (1M) and it seems to be working on my side. If possible, could you try again with something like LIMIT
on yours? And it’d be nice to perhaps create a GitHub issue with some info like, table schema, data volume, your environments, questdb version, etc. so our team can try to reproduce.Jack
Pei
Jack
Pei
Jack
Pei
Jack
Pei
Jack
Pei
Jack
Pei
Jack
Pei
Jack
Pei
Jack
Pei
Jaromir Hamala
create table as select …
will pick up the designated timestamp from the source table, but it won’t pick up indexes and it won’t pick up even partitioning. I’ll check whether it’s intentional and why.
quick thoughts: the inner select might be more complicated than just a simple select * from ...
. It can have an arbitrary projection, predicates, it can also include functions, aggregations, etc. So there is not always 1:1 mapping between source and target columns. I reckon the case with 1:1 mapping (=table cloning) is frequent enough to be treated as a special case. But this has to be properly evaluated. The last thing we’d want is to create additional confusion when some create from select
queries do clone indexes & partitioning, others don’t and it’s not immediately obvious why they behave differently.Jack
Jaromir Hamala
create table clone as (
select * from 'blueprint'
), index(symb) timestamp(ts) PARTITION BY DAY;
there is currently no single command to clone a table including all options.