Stack Overflow
Stack Overflow

Questions tagged [dbvisualizer]

DBVisualizer is a popular database tool by DbVis Software AB. Written in Java, it runs on Windows, Mac OS X, and Unix/Linux, and will connect to any JDBC enabled database server.

DBVisualizer is a popular database tool by DBVis Software AB. Written in Java, it runs on Windows, Mac OSX, and Unix/Linux, and will connect to any database server.

214 questions
1
vote
0 answers

Query in RedShift using DBVisualizer fails in a particular instalation

I am running the following query in dBVisualizer select top 100 * from analytical.dwh_sales where _material = '000032'; And is working propertly But when the same query is executed in another computer (an export from my dBVisualizer installation to…
Jonathan Raul Tapia Lopez
  • 1,383
  • 9
  • 25
  • 31
1
vote
2 answers

Postgres, is query performance depending on front-end tool?

I was trying the same query select column_1, count(1) from table group by 1 order by 1 desc with several front-end tools, and I was getting very different results.(I ran query several time to avoid anomalies or cashing issues) I always thought…
Baker
  • 425
  • 1
  • 7
  • 20
1
vote
2 answers

SQL, query that finds if two given names have the same number in one column

I have been trying to solve this for about a week now. I really need someone's help. I will be given two or three "LN"s and I have to check if they have the same number in the column "FODEX". Then maybe just add a column and print one if they have…
Data_sniffer
  • 588
  • 1
  • 8
  • 19
1
vote
1 answer

Error while connecting to Phoenix ERROR 103 (08004): Unable to establish connection

Am trying to establish connection to Phoenix, using DBVisualizer but getting below error Followed steps give here https://community.hortonworks.com/articles/19016/connect-to-phoenix-hbase-using-dbvisualizer.html After which getting error as below…
Adarsh H D Dev
  • 588
  • 7
  • 29
1
vote
1 answer

sync data between two postgres database tables

I have a db1 table A, and db2 table B i want to insert only non-existing rows from table A to table B and if data already exist in table B, update it. what is the best way to perform this? i have hundreds of rows to insert and update and many…
stackmj18
  • 103
  • 2
  • 12
1
vote
1 answer

Dbvisualizer view table relationship

I have a postgresql database with some tables. These tables have primary keys, but when I opened dbvisualizer, it didn't show me the relationships between tables. How can I get the result with relationships?
Artsom
  • 11
  • 2
1
vote
2 answers

Get record count of each table?

I have 700 tables, and I want to know the record count of each table using dbvisualizer. How can do simply and effective? Help me.
Venkat
  • 20,802
  • 26
  • 75
  • 84
1
vote
1 answer

Cannot see "Null" value in Redshift table column

I have a table in redshift with following columns in create statement ExpiryDate Timestamp without time zone NULL Encode zstd, IssueDate Timestamp without time zone NULL Encode zstd, RewardNumber varchar(64) …
Saurabh Singh
  • 11
  • 1
  • 3
1
vote
0 answers

Datagrip Intellij Cassandra SSL connection

Looking for any suggestions connecting with an SSL enabled Cassandra cluster with Datagrip / Intellij / DBVisualizer or any other DB admin tool. Solution #1 I've tried using the PEM files in the Intellij SSL tab that used for connecting with cqlsh.…
MichaelB
  • 373
  • 4
  • 13
1
vote
1 answer

Connect Oracle SQL developer to Microsoft SQL server 2017

I recently installed Microsoft SQL server 2017 on my computer and I also installed Microsoft SQL Management Studio and everything seems to work pretty well. One of my colleague told me that I could use a third party Database manager, so I was trying…
MoeDia
  • 11
  • 1
  • 3
1
vote
1 answer

Executing MYSQL Stored Procedures using DBVisualizer

I am using DBVisualizer for the first time. I have made a stored procedure in mysql database. However I am unable to execute it from DBVisualizer. This is how the procedure looks like. Here // is used as delimiter. I have four columns in the table…
Piyush
  • 11
  • 1
  • 3
1
vote
1 answer

Connect R to Vertica DB for data transformation and modelling?

I have recently started working on Vertica Database using DBVisualizer. Given that I have experience in R and am quite comfortable, can anyone help me understanding what all I'll need to connect to Vertica from R (RStudio) and execute the…
Suryakant
  • 19
  • 3
1
vote
2 answers

Removing Duplicate Rows in SQL

I have a query that returns a list of devices that have multiple "moved" dates. I only want the oldest date entry. I used the MIN function to give me the oldest date, but I'm still getting multiple entries (I am, however, getting less than before).…
TaRan
  • 37
  • 10
1
vote
1 answer

Hive connection to dbvisualizer using Kerberos Authentication

I am using windows machine and trying to setup hive with DbVisualizer using hive uber jar. However getting the error as mentioed below. Not sure why ? https://github.com/timveil/hive-jdbc-uber-jar I am using following exe to generate keytab file…
Gaurang Shah
  • 11,764
  • 9
  • 74
  • 137
1
vote
1 answer

Creating HSQLDB Procedure in DbVisualizer

I am trying to create the following simple HSQLDB procedure, by a DbVisualizer client. DROP PROCEDURE IF EXISTS my_procedure; CREATE PROCEDURE my_procedure(OUT my_output INTEGER, IN my_input INTEGER) MODIFIES SQL DATA -- NO SQL BEGIN…
rapt
  • 11,810
  • 35
  • 103
  • 145
1 2 3
…
14 15