It's easy to do this but the down side is that your database has to be down.

Hi Jim,

What do you mean ?

Should i stop the database before proceeding the steps given by you?????

And then i start the database after completion of this process??

Thanks,
Raj.

Hi,

I tried in the following way..
Please find the attachment.

Thanks,
Raj.

hi Daniel,


i am getting an error while creating the Library.
Please find the attachment.
Correct me if i am wrong.

Thanks,
Raj.

Daniel, Split_Part () function only returns the single value in a string present in the given position. But what if i want to split all the data (separated with a delimiter) in a string to be appear in multiple rows? Eg: Select Split_Part('Raj|Skwa|vertica|database','|',2) Result is : Skwa But i wan...

Hi,

what are the maximum number of tables that can be created in a schema in vertica?

Thanks,
Raj.

Hi,

Im unable to Understand the Explain Statement Result..

What is the acceptable cost?

What cost if it exceed lead to low performance?

Please tell me , how to understand the EXPLAIN statement result.

Thanks,
Raj.

Hey Rick,

Its done.. Mysql is the right answer.

-Raj