Questions tagged [dbeaver]
DBeaver is a free and open-source (Apache License 2.0) universal database tool for developers and database administrators.
dbeaver
1,157
questions
0
votes
0
answers
11
views
How to use explain in SPARQL queries to AWS Neptune in DBeaver
It is necessary to analyze performance and the query plan of a SPARQL query to AWS Neptune inside DBeaver CE IDE.
Neptune documentation describes explain option but it is passed inside the HTTP ...
- 103
0
votes
1
answer
16
views
Grouping column and the result will be display horizontally
I'm trying to workout on how to get the result horizontally using group by and family column values should be display horizontally.
I want to find what are the itemid that used familys.
CREATE TABLE ...
- 147
0
votes
0
answers
30
views
How to call Spark SQL with limit and clear this memory without restating the Thrift server
I'm using DBeaver to connect to a Hadoop environment with Hive (port 10000) and Spark (port 10001). I'm encountering two issues:
Spark SQL LIMIT syntax error:
When connecting to Spark and checking ...
0
votes
1
answer
11
views
An error occurred when using DBeaver to connect to PieCloudDB
I am trying to connect PieCloudDB Database with the DBeaver client , but when I execute SQL, an error occurs: prepared statement "stmtcache_XX" does not exist. I don't know what happened, ...
- 57
0
votes
1
answer
42
views
Connecting from DBeaver using Astra JDBC driver returns "Invalid Credentials"
I need to connect to Astra using DBeaver. I'm following guide https://awesome-astra.github.io/docs/pages/data/explore/dbeaver/#astra-community-jdbc-drivers (exactly "Astra Community JDBC Drivers&...
- 905
0
votes
1
answer
89
views
Connecting PostgreSQL running on WSL from DBeaver on Windows (FATAL: password authentication failed for user "postgres")
I have my WSL2 running an Ubuntu 20.04 distro. I have installed my PostgreSQL (12.19) using apt-get.
I ran sudo passwd postgres to set password as root
I am able to access the DB from the WSL terminal ...
0
votes
0
answers
33
views
Bulk Table export as DDL separated files in DBeaver
I am trying to export and entire database's schemas for tables, views, etc.
I must export the schemas as SQL individual files.
I've been doing it manually through the option generate SQL-> DDL but ...
0
votes
0
answers
41
views
How to configure an external formatter in DBeaver Snap Linux?
I'm trying to configure an external formatter for SQL queries in DBeaver, but I'm encountering a "permission denied" error. I'm not very experienced with the command line and just started ...
1
vote
0
answers
33
views
DBeaver - Set default Column Target Type for CSV Import data
I am trying to import a large number of CSV files as tables into DBeaver. With each CSV file, DBeaver seems to guess the column target type. Is there a way to stop this from happening? I want every ...
- 627
1
vote
0
answers
21
views
DBeaver disable ctrl+click = definition
My goal is disable ctrl+click leads to table definition.
I've searched and I've gone through most of the preferences. I even exported them to a csv file to try and search them for the thing to disable....
- 189
2
votes
2
answers
65
views
Postgres truncating timestamptz value to 3 places?
In my postgres database I have a table I'll call users with a timestamptz type column updated_time. When I execute a select statement on this field I will get something like this - '2024-07-01 12:30:...
- 385
0
votes
1
answer
58
views
View the definition of an existing table in PostgreSQL
I tried to get the query of an existing table in PostgreSQL database using DBeaver IDE. Query which was used to create the table and its relationships.
I tried mentioned below 4 queries but those are ...
- 16.6k
0
votes
1
answer
53
views
Connect to ADW with not ADMIN user in DBeaver
I have already created my ADW. I can connect to it with my ADMIN user (ussing the wallet) with Dbeaver. The connection configuration looks like this:
I have created a user for other person to connect ...
- 823
1
vote
2
answers
59
views
Getting SQL error in DBeaver connecting to Cassandra "NoNodeAvailableException: No node was available to execute the query"
There is a problem with working with Cassandra in DBeaver.
Cassandra 4.0.12
Cassandra JDBC Driver 4.9.0
After executing a simple Select query (SELECT * FROM tbl_file), an error occurs:
SQL Error: com....
0
votes
2
answers
94
views
Oracle - How to build a dynamic query for use in DBeaver
I come from a SQL Server background. How should I write the below to be able to run in DBeaver against an oracle database? I got bits of it from other questions here but cannot make it work in full.
...
- 49