I am new in Accumulo and currently trying to migrate all of data from relational database such as PostgreSQL and Oracle to Accumulo. How do I do this? Is there a direct API that I can use or do I…
I'm running postgres (14) database that I installed on an Ubuntu compute instance to which I fail to connect remotely: ~$ psql -U postgres -h remote.server.address -p 5432 datadb psql: error: connection to server at remote.server.address, port 5432 failed: Connection…
I have a table with first_name, last_name and name. Name consists of a full name such as "Joe Bloggs". I want to update every row in the table with first_name and last_name derived from the name column, but I just…
I was asked this question in a job interview: There is a table with vehicle names mentioned in a column. Output when we check for name=car we must get as 4 i.e the maximum count of continuous occurrence of 'car'…
I am using IN operator in a non conventional manner, with a literal value on the left side and columns on the right side So instead of: (table1.id = 123 OR table2.id = 123 OR table3.id = 123) I use:…
I can't execute sql query, that has to rename the table to the same name as type, that already exists. I have not found any rules or comments about the same name for different things in postgres. CREATE TYPE ratings.processed_sport_bet…
I search a solution for my problem in SQL (postgresql). I have a logs table with the following columns: deviceId id code timestamp device1 1 12 1672597471000 device1 2 11 1672597471001 device1 3 8 1672597471002 device1 4 2 1672597471003 device1…
Arrays seem really simple in PostgreSQL, but I am having trouble with JSON parsing into an array column type. The Json data contains a property with an array value: "problems": ["/problems/22", "/problems/31"], The table has an array-type column like: CREATE…
It seems to me that Postgres is ignoring my envar and the sql script Here's my docker-compose version: '3.1' services: db: image: postgres restart: always environment: POSTGRES_PASSWORD: mysecretpassword PGDATA: /var/lib/postgresql/data/pgdata POSTGRES_DB: ecommerce volumes: - /custom/mount:/var/lib/postgresql/data - ./sql_script.sql:/docker-entrypoint-initdb.d/sql_script.sql ports: - 5432:5432…
I want to see on page all text that is saved in database, but i want it to be like a list of text example That the first text from data base Here is the second one. I try like…