For example use Test table with only positive id value. Query select 1 from public.Test where id = 0 return empty result. But when I use this query: select case when exists(select 1 from public.Test where id = 0) then ‘exist’ else ‘not exist’ end result is – not exist For query: select case when… Read More PostgreSQL EXISTS and null value
I have a query that return values based on a boolean column: if the id_crsp includes a boolean true AND false, then it is selected. Values of id_crsp that have only a true or false value are not selected. From this result, I would like to sort the id_crsp which have duplicates, and select only… Read More SQL – How to get a duplicate column based on the value of another column
Some mock data: test_data = [(‘1’, ‘[tech, fx]’), (‘2’, ‘[industry, computer]’), (‘3’, ‘[5G, Apple]’)] test_data = spark.sparkContext.parallelize(test_data).toDF([‘id’, ‘text’]) I wan’t to create a new column that indicates if the words [‘fx’, ‘computer’] can be found in the column called ‘text’: Desired output: result = [(‘1’, ‘[tech, fx]’, ‘1’), (‘2’, ‘[industry, computer]’, ‘1’), (‘3’, ‘[5G, Apple]’,… Read More How to check if at least one element of a list is included in a list column?
Tables and code at the bottom will probs help much more than description. I have a solution that works but think its very inefficient see bottom. Problem: I have two data frames df_1 and df_2 — these dataframes have a match column – match_id df_2 has a date column that I am trying to write… Read More Python: Filling a dataframe sequentially based on matching ids (inefficient code)
I’m requesting data from an API that requires paging records based on a custom header called "cursor". Only 100 records may be retrieved per call and as such I’ve created a while loop to execute. The loop functions… until it doesn’t. Once all records are paged, the headers get dropped and my program errors out… Read More How to handle "The given header was not found" when paging records in c# API GET request?
I am trying to retrieve a password hash that i stored in my database. The problem is how i handle when the query is null. In the case that I search for a user that exists the first print will print something but the in the second print that is inside the if statement it… Read More Python variable loses value when passed to a if statement
I was plying with higher order functions, and I started getting different results when I created two instances and assigning them to variables. I reduced the issue to the following example: #include <iostream> using ColorGetter = int(*)(void); auto paint(const ColorGetter &f) { return [&]() { return f(); }; } int colorA() { return 10; }… Read More C++ higher order functions: different results when declaring multiple functions
I have a question regarding Mongo indexes for a $or request on two ObjectID fields. How can I make sure a search will first look at the first argument of the $or expression and only then if no match looks at the second or should we split it into two requests and add this logic… Read More How to add index weight on two id fields on MongoDB?
I have a SQL database: 3 desks, and what they contain and I need to extract only the items that are unique on each desk and the desk the items are on.The task looks disturbingly easy but my brain can’t comprehend the extra SQL commands, therefore I have 0 idea how I could get the… Read More SQL select unique items from everyone's desk
I’m trying to do a comparison between a value, if it exists in Json, using "if and else", but it always falls into the "else" condition first. my code: with open(arquivo, ‘r’) as f: data= json.load(f) data2 = data["Privado"] baka = 1199736520 #Id exists in json for s in data2: abc = s["id"] if baka… Read More how to make a functional "if" condition using Json in Python?