The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

General Discussion

Archives for April 2021

using EXCEPT to compare 2 tables on 2 different vertica db's.

Answered kfruchtman 4.6K views 6 comments 0 points Most recent by SergeB May 2021General Discussion
Restore from full backup FAILED

Question BETEPOK 395 views 0 comments 0 points Started by BETEPOK April 2021 General Discussion
User priviliges do not work as expected

Answered ✓ joergschaber 1K views 1 comment 0 points Most recent by Jim_Knicely April 2021General Discussion
Is there a way to return the number of messages sent to Kafka using KafkaExport?

Answered HyeontaeJu 3K views 4 comments 0 points Most recent by SergeB April 2021General Discussion
JDBC pools for dashboard sessions

Answered kfruchtman 3.6K views 5 comments 0 points Most recent by dave_wood May 2021General Discussion
Exporting access policy

Answered zadvovl 918 views 2 comments 0 points Most recent by Hibiki January 6General Discussion
Vertica + grafana 7.5.4

Answered kfruchtman 5K views 7 comments 0 points Most recent by s_crossman May 2021General Discussion
MERGE Query

Answered reli 1.1K views 1 comment 0 points Most recent by dave_wood May 2021General Discussion
AHM not advancing

Answered stestaz 3.6K views 5 comments 0 points Most recent by Jim_Knicely April 2021General Discussion
Node recovery during live etls and user operations.

Answered SK21 1.2K views 1 comment 0 points Most recent by baron42bba July 2021General Discussion
Tuple Mover fails out of memory

Answered mark_d_drake 1.7K views 2 comments 0 points Most recent by mark_d_drake April 2021General Discussion
Is it a good idea to run purge every hour?

Answered tarundev2003 1.7K views 2 comments 0 points Most recent by Jim_Knicely June 2021General Discussion
MC cannot import the db with error: "Error while getting cluster for IP: x.x.x.x"

Question kfruchtman 398 views 0 comments 0 points Started by kfruchtman April 2021 General Discussion
VSQL: Set variable to result of query.

Answered ✓ mark_d_drake 2.2K views 2 comments 0 points Most recent by mark_d_drake April 2021General Discussion
NewBie Question. Multiple inserts fail after 1024 operations in a single transaction)

Answered mark_d_drake 2.4K views 3 comments 0 points Most recent by mark_d_drake April 2021General Discussion
Copy statement fails in 10.1, works in 9.0

Answered mark_d_drake 1.7K views 2 comments 0 points Most recent by Hibiki July 2021General Discussion
Deleting unused projections

Answered ✓ yamakawa 1.8K views 2 comments 0 points Most recent by yamakawa April 2021General Discussion
Excel Convert Date To Number in Vertica

Answered ✓ reli 2.4K views 3 comments 0 points Most recent by Jim_Knicely April 2021General Discussion
Vertica +Vertica-Grafana plugin versions

Answered kfruchtman 3K views 4 comments 0 points Most recent by kfruchtman April 2021General Discussion
I can't convert archer(128) to varchar(64)

Answered ✓ sergey_h 3.7K views 5 comments 0 points Most recent by sergey_h April 2021General Discussion
Recovery gets stucked during live operations.

Answered SK21 1K views 1 comment 0 points Most recent by SK21 April 2021General Discussion
Problem with FJSONParser

Answered jsipek 1.1K views 1 comment 0 points Most recent by jsipek April 2021General Discussion
cannot conenct to sftp site -timeout

Answered ✓ sreeblr 1.8K views 2 comments 0 points Most recent by sreeblr April 2021General Discussion
vertica error "The [TimeSeriesModel] [tag] in [PMML] is not supported yet"

Answered pinghao 1.1K views 1 comment 0 points Most recent by SruthiA April 2021General Discussion
Regarding backup

Answered Sathya 1.1K views 1 comment 0 points Most recent by Vertica_Curtis April 2021General Discussion
TIME_SLICE

Answered kfruchtman 4.5K views 6 comments 0 points Most recent by kfruchtman April 2021General Discussion
Performance troubleshooting of the queries on a dashboard.

Answered kfruchtman 1.7K views 2 comments 0 points Most recent by kfruchtman April 2021General Discussion
How to load JSON array of primitives into column with array type

Answered ✓ scherepanov 1.9K views 2 comments 0 points Most recent by scherepanov April 2021General Discussion
date_trunc return type is timestamp, even if argument is date

scherepanov 3K views 3 comments 0 points Most recent by Jim_Knicely April 2021General Discussion
flattened tables question

Answered kfruchtman 3.7K views 5 comments 0 points Most recent by kfruchtman April 2021General Discussion

General Discussion

Discussion List