Stack Overflow
Stack Overflow

Questions tagged [dbeaver]

DBeaver is a free and open-source (Apache License 2.0) universal database tool for developers and database administrators.

DBeaver is a free and open-source (Apache License 2.0) universal database tool for developers and database administrators.

  • Usability is the main goal of this project, program UI is carefully designed and implemented.
  • It is freeware.
  • It is multiplatform.
  • It is based on an open-source framework and allows the writing of various extensions (plugins).
  • It supports any database having a JDBC driver.
  • It may handle any external datasource which may or may not have a JDBC driver.
  • There is a set of plugins for certain databases and different database management utilities (e.g. ERD).
1047 questions
-1
votes
1 answer

Using the results of a function multiple times for duplicates - SQL

I am trying to produce a result that shows duplicates in a table. One method I found for getting duplicates and showing them is to run the select statement again through an inner join. However, one of my columns needs to be the result of a function,…
Koolachoo
  • 1
-1
votes
1 answer

SQL Error [42501]: The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation

'''Hi I try to connect to IBM DATABASE using DBrieaver . But, when i try to see the data in tables. I am getting the following errors. SQL Error [42501]: The statement failed because the authorization ID does not have the required authorization or…
krkr143
  • 19
  • 1
  • 4
-1
votes
1 answer

table1.date1 = get prior 12 months data from date1 in table2.monthyear in Athena? how to get 12 months prior data in year month?

select amt1, amt2 from table2 inner join table1 on table1.field1 = table2.field2 and table2.month_year between (substring(table1.date1,1,6) -12 month)
Dee
  • 31
  • 1
  • 1
  • 5
-1
votes
2 answers

Unable to connect my oracle db after restart

I m trying to connect oracle DB in DBeaver so it was working fine and I can able to fetch data and able to connect it but after restarting my system I am getting the below error in the DB connection. If I try to connect the Same DB from my local…
CodeChanger
  • 7,953
  • 5
  • 49
  • 80
-1
votes
1 answer

Is there any way to see the categorical content of a specific column?

If, for example, a SQL 'categorical' column measures extreme, high, medium, low or no risk, I would like to see those values as output from a SQL query. I can't find it anywhere. Is it possible? Thankyou.
EduardoCabria
  • 29
  • 1
  • 4
-1
votes
1 answer

How to list all primary keys in database?

i'm at the very start of learning about how to code and started from SQL and Python. I have a task: to list all primary keys in data base. How can I do it? Diagram I used select * from public But it returns with error
Lev Baikov
  • 1
-1
votes
1 answer

How would I combine these 2 SQL statement?

select to4.ProportionOfRoute, to4.RouteID from tbl_operatorrouterelation to4 where to4.operatorID = ( select to2.operatorid from tbl_operatordesc to2 where to2.Name = "OK Travel" ) select tr.Frequency, tr.routeID from tbl_route…
7up234
  • 5
  • 3
-1
votes
1 answer

SQL Join help needed field type doesn't match for duration information

I am trying to join two tables with SQL. I am looking to have the cost from table 2 added to table 1. The cost used to only vary by Service so it was a simple join, but the data has changed and now the cost also varies depending upon location and…
Sarah Mc
  • 37
  • 6
-1
votes
2 answers

Unable to access column names from information_schema (MySQL/MariaDB)

I'm trying to get column names from a specific table. EDIT: I forgot to mention it initially, but the python script i.e. gets the table names without any issues (different query), but the one selecting column names runs into an error. When I write…
sushiPlague
  • 23
  • 1
  • 6
-1
votes
2 answers

How to back tab in dbeaver?

I pressed tab too many times. Usually to undo the tab I press ctrl+[ in vscode. What is the equivalent for dbeaver? --For example select productname from products where productid in …
calvindio
  • 347
  • 3
  • 11
-1
votes
1 answer

Invalid identifier error when using RIGHT JOIN inside FROM clause

I want to use within a FROM a subset of 2 tables using RIGHT JOIN (I want from that subset all the rows of ITV2_VEHICULOS whose ID is not in ITV2_HIST_VEHICULOS) so that the SELECT "takes" the data from there and with the WHERE it can filter My…
Raulitus
  • 43
  • 1
  • 8
-1
votes
1 answer

Error on MariaDB transaction attempt

I'm trying to perform this transaction on MariaDB 10.1.25 on Fedora 25 and DBeaver as sql editor. Each query alone works fine, but when wrap them on the transaction block always fails. BEGIN; INSERT INTO quality.tb_account (email, password,…
rojoherrero
  • 1
  • 1
-1
votes
1 answer

How to configure DBeaver for Ubuntu, PostgreSQL?

I'm new to DB viewers and DBeaver. I installed DBeaver on Ubuntu 16.04 to view the DB tables of my project, chose 'PostgreSQL', entered username and password, clicked 'test connection' and got an error: Connection to localhost:5432 refused. Check…
Evanto
  • 340
  • 4
  • 19
-1
votes
1 answer

QUERY [VIRTUAL] [ERROR] in DBeaver while querying the table in Denodo

I ran this query in DBeaver SELECT DLY.badge_nbr, DLY.DIM_DT_ID,attribute_type FROM FACT_MDM_DAILY_INT DLY WHERE SCENARIO_TYPE = 'VOLTAGE' AND ATTRIBUTE_TYPE = 'Phase_A_Average_RMS_Voltage' AND DLY.dim_dt_id >=…
Ajaya Rk
  • 5
  • 1
  • 7
-1
votes
1 answer

Join query is not working in Cassandra

i am new to Cassandra and i tried a simple join query like this $result = new Cassandra\SimpleStatement(<<
jignesh patel
  • 11
1 2 3
…
69
70