Mysql – Upsert using DuckDB
Let assume I have two parquet file aka main and updates with some data as shown below. I need to implement upsert kind of operation in duck db. parquet file main: id, name, city data: id name city 1 a…
Postgresql – How to select from a table all records for which there are other records in this table with certain parameters?
I have a table like this in Postgres: user_id project status 1 p1 finished 2 p1 finished 2 p2 finished 2 p3 finished 3 p1 finished 3 p2 finished 3 p3 finished 4 p1 finished 5 p1 finished 6 p1…
Exploding Column in Mysql Databricks row-wise
I have an array type column subscription in my table with columns Sample Table +-------+--------+----+----------+ |user_id| Subscription|Activity | +-------+-------------+----------+ |111 |[A,C,B] |20 | |-------+-------------+----------+ |222 |[C,A] |10 | |-------+-------------+----------+ |333 |[B] | 5 | +-------+-------------+----------+ I want to change my…
How to classify groups based on changes from the previous period in PostgreSQL?
Good day to everyone! I have a table with some teams and their rating for the period. Data looks like this: team date rating team_1 2022-09 7.5 team_1 2022-12 8 team_1 2023-03 8.5 team_2 2022-09 8 team_2 2022-12 7 team_2…
How to count number of people for each month, who was on internship, if we know dates of internship – Postgresql
First of all, sorry for bad title - I can't figure out how to write generalized formulation of my problem. I have a table in PostgreSQL with users and dates of their internships. It looks like this: user_id start end…
GROUP BY function ret – Mysql
start end category 2022:10:14 17:13:00 2022:10:14 17:19:00 A 2022:10:01 16:29:00 2022:10:01 16:49:00 B 2022:10:19 18:55:00 2022:10:19 19:03:00 A 2022:10:31 07:52:00 2022:10:31 07:58:00 A 2022:10:13 18:41:00 2022:10:13 19:26:00 B The table is sample data about trips the target is to calculate…
Mysql – How to give " Only in " condition in SQL?
I have a table that has columns Name, Series and Season. Name series season abc alpha s1 abc alpha s2 pqr alpha s1 xyz beta s2 xyz gamma s3 abc theta s1 I am trying to extract the number of…
Postgresql – How do I extract the month from the Date column in SQL-postgres
I am trying to extract the month from the the Order_date column by using postgres SQL , and the format is required to come in the name of the month format ;for example, December. When I applied the extract function…
when i want to run my code on docker container i get a path error
I have a python code. The code checks the folder A every 15 seconds and if there is a csv file there, process it and generates an html report with the same name. I want to run my code on…
how can i run a python code periodically on a docker container
I have a python code which works for doing data analytics from csv file. I want to run my python code to be run periodically on a docker container. Every 15 seconds, it should automatically look at a folder A,…