ClickHouse’s Post

Check out how Goast auto-fixes issues from the SWE-Bench dataset!! 📽 In the second installment of our demo series, Cameron chooses to fix a random exception from the SWE-Bench dataset. Given only the stack trace, Goast is able to generate a solution that passes ALL the tests in the FIRST TRY. No iteration needed! Stop wasting time dealing with issues from you error log. Book a demo with us and you'll be breezing through errors in seconds! Seriously. Book a demo here: https://lnkd.in/eTe_e56v

There's so much more to VIN than the message boards. Explore beyond the tip of the iceberg with a deep dive into VIN. Sessions are open to any questions you have about using VIN! https://lnkd.in/d8v3G_Y

Did you know that Clickhouse can store and query vectors? 🚀 Linear scan We wanted to see how well it would do querying vectors without using any indexes. Verdict: not too bad! 📚 The dataset We used Qdrant's awesome Wikipedia dataset which contains 1 million Wikipedia entries and associated 1536 dimension embeddings. 🧩 Aggregating data We used the new arrayShingles function to extract common phrases for the articles returned by the vector search.

Array functions in ClickHouse are so much fun that we had to make another video showing off a few more functions. In this video, we analyze Mark's Strava running data 🏃♂️ with help from the following functions: 🟡 arrayDifference to compute the difference in pace between splits. 🟡 arrayMap to convert the pace differentials into colored bars. 🟡 arrayStringConcat to convert the colored bars from an array into a string. What's your favorite array function? What should we cover next? 🤔

StepMix v2.2 is out! https://lnkd.in/eWXf26XP 1. Supervised mixtures for classification 2. BLRT for testing the number of components StepMix follows the scikit-learn API for fitting mixtures of continuous and categorical data with missing values. Check it out!

Array Map and Filter methods The array map method is used to traverse the array, perform some functions or changes, and return a new array without changing the original. The array filter method will return the values which satisfy the given condition inside the array filter method. /*---Array Map and Filter Methods---*/ /*-----Array Map Method-----*/ const arr:string[] = ["Mango","Apple","Banana","Kiwi"]; const fruit:string[] = arr.map((curValue:string)=>{     return curValue.toUpperCase(); }) console.table(fruit); /*----Array Filter Methods----*/ const filteredFruit:string[] = arr.filter((curValue)=>{     return curValue!=="Mango" }) console.table(filteredFruit); #day12 #40daysofTS

BBQvec: A scalable vector search library #VectorSearch #ScalableSearch #InformationRetrieval #MachineLearning #SimilaritySearch #NaturalLanguageProcessing #ComputerVision #ArtificialIntelligence #SearchEngineOptimization #NearestNeighborSearch https://lnkd.in/gNc-96Hg

We just released 𝗦𝗲𝗲𝗸𝗦𝘁𝗼𝗿𝗺 𝘃𝟬.𝟮.𝟬 𝘄𝗶𝘁𝗵 𝗙𝗮𝗰𝗲𝘁𝗲𝗱 𝘀𝗲𝗮𝗿𝗰𝗵: String & Numerical range facets with counting and result filtering. This is our biggest feature update so far, with over 3000 LoC added - and uncompromised performance. Here is an overview of the new features together with code snippets:  https://lnkd.in/eqBJ8cuN Enjoy! #Search #FacetedSearch #LexicalSearch #Rust #OSS