October 23, 2024
Chicago 12, Melborne City, USA
SQL

Cannot perform Merge: multiple source rows matched in Delta Table

I am facing an issue while performing a MERGE operation on my Delta table. The error message I receive is: Cannot perform Merge as multiple source rows matched and attempted to modify the same target row in the Delta table in possibly conflicting ways. I have verified that there are no duplicates in the primary

Read More
python

How to split my dataset into Test and Train without repitition?

I am developing a Python script to test an algorithm. I have a dataset that I need to split into 80% for training and 20% for testing. However, I want to save the test set for further analysis, ensuring no overlap with previous test sets. Although my code works well overall, I encountered one issue:

Read More
java

HikariCP-Oracle Connection Pool Recreated on Every Invocation in Java Micronaut Azure Function

I’m working on a Java application built with the Micronaut framework that leverages Azure Functions for a serverless design. The application connects to an Oracle database. However, I’ve encountered an issue where a new connection pool is being created on every single function invocation. This leads to a rapid increase in the number of active

Read More
python

Return current angle of turtle in Python?

How can I get the current angle of the turtle? I need to check if the turtle is facing east or west (positive or negative) to make a DVD Video Screensaver. I’ve looked through every turtle function and through StackOverflow and I can’t find anything. You need to sign in to view this answers

Read More
python

Tensorflow errors: cuFFT, cuDNN, cuBLAS and “Assertion '__n < this->size()' failed”

I just started with TF and Keras and found out that I can’t run these on my computer. I’ve notice the problem first in jupyter notebook, and than recreate it in a python file. The code to reproduce (main.py): import os os.environ["KERAS_BACKEND"] = "tensorflow" import keras from keras import layers from keras import ops print("pass")

Read More
security

Chrome disable SSL checking for sites?

I’ve created powershell script which open particular url. Now I have a problem: before openning this url I’ve got a pop-up with information about ‘Your connection is not private’. How to avoid this security task? #paths to Chromium needed executables $Chromium="C:\Program` Files\Google\Chrome\Application\chrome.exe" #... # some code #... elseif ($i -eq 5) { Start-Process -FilePath $Chromium

Read More
PHP

How to Update Textarea Values in Filament Component with JavaScript?

i want to update the value of textarea with java script but when i submit the words i can only get data that users typed directly inside textarea and not changes by javascript what should i do? here is my code: Translate::make() ->locales(['fa', 'en']) ->columnSpanFull() ->columns(2) ->schema(fn (string $locale) => [ Forms\Components\Select::make('variables') ->extraAttributes([ 'onchange' =>

Read More
python

I can't install the Spacy library using the terminal in VSCode on Windows 10

I am trying to install the Spacy library in VSCode in a folder with a virtual environment. The output appearing in the terminal is excessively long; I will share it with a [pastebin](https://pastebin.com/xK9UYbEy) later. My version of Python is Python 3.13.0 and pip is pip 2.42, so they are up to date. I think the

Read More
security

How can I detect azure cloud defender recommendations early?

Is there a good way to prevent defender for cloud recommendations/warnings before doing changes? Defender for DevOps usually deals with SAST scanning on repos, but the warnings I’m interested in blocking are terraform changes that modifies/creates resources in Azure that in turn leads to defender for cloud warnings. For example Using Storage account with SAS

Read More
SQL

Create a MS Access Pivot Query that returns rows even if there are null values

I’m trying to create a pivot table in MS Access based on an Employee List table, a Skills list table, and a table that contains data on what employee has what level of training for each skill. The table should return default values if there is no row found in the still level table. Employee

Read More