hehe

22 posts

hehe

hehe

@hehe18898613

Katılım Şubat 2022
12 Takip Edilen0 Takipçiler
hehe
hehe@hehe18898613·
@ClickHouseDB I want to know how to forcibly end a query,I have a query that took thousands of seconds to execute, using kill query_ Ii cannot be terminated
English
0
0
0
45
ClickHouse
ClickHouse@ClickHouseDB·
Learn how to query individual DataFrames, how to join them together, and how to generate a new DataFrame from the results. All with the power of ClickHouse and chDB clickhouse.com/videos/queryin…
English
3
5
22
8K
hehe
hehe@hehe18898613·
@fulmicoton @Etsy Sorry, my network cannot access the discord server
English
1
0
0
16
Paul Masurel 🦀
Paul Masurel 🦀@fulmicoton·
I ask companies using tantivy to send me a quote to put on quickwit.io. People usually reply in a day. It is free, it helps the project and it is good PR for everyone. Today, for the first time a company refused: @etsy. It is our heaviest user. They had job postings with tantivy listed in it.
GIF
English
6
1
17
4.6K
hehe
hehe@hehe18898613·
@fulmicoton @Etsy The Grafana plugin, it seems that my configuration script does not work.
hehe tweet media
English
0
0
0
18
hehe
hehe@hehe18898613·
@fulmicoton @Etsy Which service is it for modifying source data (such as modifying checkpoint information, file location information, and kafka location information)? Indexer service? Metatore service?
English
2
0
0
26
Paul Masurel 🦀
Paul Masurel 🦀@fulmicoton·
Today, if you need availability yes. If you can live with waiting for the metastore service to restart when it fails, then no. There are no tools today to migrate your existing metastore from s3 to postgreSQL. We can build one for you but this won't be free. We can also build an available metastore on S3, but again, this won't be free.
English
1
0
0
63
hehe
hehe@hehe18898613·
@fulmicoton @Etsy this is my metastore config: metastore_uri: s3://quickwit/meta Do I have to switch to postgreSQL? If the metastore service crashes, will the cluster be unable to index and search normally Also, what do I need to do to migrate metastore from s3 to postgreSQL
English
1
0
0
90
Paul Masurel 🦀
Paul Masurel 🦀@fulmicoton·
Janitor can fail without any problem. Control plane needs to be restarted, but the cluster will continue searching and indexing while they are not there. If you are on K8s the pod restarting somewhere will do the job. Source data you mean metastore? Today the metastore has to be postgres if you want your cluster to be available.
English
1
0
0
85
hehe
hehe@hehe18898613·
@fulmicoton @Etsy My main concern is that these node failures may cause the cluster to become unavailable, and my source data is stored in s3. So, I can't deploy multiple nodes anymore
English
1
0
0
65
Paul Masurel 🦀
Paul Masurel 🦀@fulmicoton·
@hehe18898613 @Etsy This is a strange thread to ask your question. The control plane and the janitor must be unique. The metastore must be unique IFF you are using the file based metastore. You can have several metastore if you use the postgres metastore.
English
1
0
1
262
hehe
hehe@hehe18898613·
@JeanMertz @vectordotdev this is my event content: {“start_time":"2022-09-05 10:07:00","tab":"media_stat","window_end_time……}
English
2
0
0
0
hehe
hehe@hehe18898613·
@vectordotdev the VRL not have the function format_int_to_timestamp? like this source:1656072405 return:2022-06-24 12:06:45
English
2
0
0
0
hehe
hehe@hehe18898613·
@JeanMertz @vectordotdev when i configured: dynamic_option = “table ={{ta}}” i got :Configuration error. error=unknown field `dynamic_option`, expected one of `endpoint`, `table`, `database`, `skip_unknown_fields`, `compression`, `encoding`, `batch`, `auth`, `request`, `tls`, `acknowledgements` for key x
English
0
0
0
0
hehe
hehe@hehe18898613·
@JeanMertz @vectordotdev when vertor is started ,i saw some information in console: headers={"date": "Wed, 29 Jun 2022 06:40:26 GMT", "connection": "Keep-Alive", "content-type": "text/plain; charset=UTF-8”, This is eight hours less than I expected
English
0
0
0
0
hehe
hehe@hehe18898613·
@JeanMertz @vectordotdev sink :clickhouse, Where can I set the time zone,because id add a field:.insert_time = format_timestamp!(now(),format:"%Y-%m-%d %H:%M:%S”),The actual time(function:now() is :2022-06-27 18:59:42 but after insert database, i saw : 2022-06-27 10:59:42?look forward to your reply
English
1
0
0
0
hehe
hehe@hehe18898613·
@JeanMertz @vectordotdev now : i tried like this: to_int!(slice!(to_string!(.data.created_time),start:0,end:-3)) and it work ok!, I don't think it's very smart
English
0
0
0
0