@becky May be... but, for 11+ ears old - Vertica has no bad achievements ;-) Due Vertica design (data replication,compression,epochs) and Julie's case it oblige to do explicit data type coercion. PS Mind if I ask you - why "business class" database must provide such functionality (modify column dat...

Hi, wlam! I don't know your needs but may be next example will be useful (see INTERPOLATE PREVIOUS VALUE): Stock table definition: CREATE TABLE Stock ( item VARCHAR(15), price FLOAT, item_ts TIMESTAMP ); Customer table definition: CREATE TABLE Customer ( name VARCHAR(25), item VARCHAR(15), purchase_...

Hi, flipperbw!

Try next (as root in /opt/vertica/config/vsqlrc or as user in ~/.vsqlrc):

Hi, Josh! Features are not supported on VCE Beta: Vertica Management Console Backup/restore Import/export Disaster recovery Workload Analyzer Geospatial functions Informatica Connector Client drivers for Linux and Windows only. (Vertica Enterprise Edition includes client drivers for Linux, Solaris, ...

Hi, piglet!

Your Vertica® Community Edition Beta download package includes a three-node license for 1TB of data.

Your attachment only says only that Vertica supports K-Safety=0 on two nodes cluster installation nothing else.

Hi, rajasekhart! Result of SELECT exceeds a VARCHAR limit length, it because length of 'SMP1' is 4 and length of 'BREVARD' is 7 and result string length of 78000-octet. Hmmm... but what interesting: source string about 2000 chars length, result string about 78000 chars length. A little math? 2000 * ...

Hi! Can you provide more info? test_db=> create table TestReplace ( col1 varchar, col2 varchar, col3 varchar); CREATE TABLE test_db=> copy TestReplace from stdin delimiter ','; Enter data to be copied followed by a newline. End with a backslash and a period on a line by itself. >> foo,bar,baz >> qux...