Hi, Nani and Kiran...
Thanks for the great information..
By the Way , where you are from..?? Im from Hyderabad..
Regards,
Raj!!
Search found 87 matches
- Mon Jul 22, 2013 6:19 am
- Forum: Vertica Database Development
- Topic: Max No Of Columns can we use in one table in vertica DB?
- Replies: 3
- Views: 8827
- Fri Jul 12, 2013 7:29 am
- Forum: Vertica Database Administration
- Topic: Can we create a linked server b/n vertica and sql server??
- Replies: 7
- Views: 16762
Re: Can we create a linked server b/n vertica and sql server
Hi,
As we are having sql jobs in MS Sql Server,
How to implement such concept(Schedulers) in vertica database.
Eg: Running a script on some intervals of time. i.e, once in a day or once in a week
Thanks,
Raj!
As we are having sql jobs in MS Sql Server,
How to implement such concept(Schedulers) in vertica database.
Eg: Running a script on some intervals of time. i.e, once in a day or once in a week
Thanks,
Raj!
- Fri Jul 12, 2013 6:03 am
- Forum: Vertica Database Administration
- Topic: Can we create a linked server b/n vertica and sql server??
- Replies: 7
- Views: 16762
Re: Can we create a linked server b/n vertica and sql server
ok thank you for quick reply..
- Thu Jul 11, 2013 12:20 pm
- Forum: Vertica Database Administration
- Topic: Can we create a linked server b/n vertica and sql server??
- Replies: 7
- Views: 16762
Can we create a linked server b/n vertica and sql server??
Hi, As we are having a feasibility to create a linked server in Microsoft sqlserver, Do we have the same feasibility in Vertica Database?? I want to create a linked server between vertica database and MS Sql server, so that i can access the data from vertica database into the MSSql server. Can we cr...
- Tue Jun 11, 2013 11:20 am
- Forum: Vertica Migration
- Topic: Migration from SQL Server to Vertica
- Replies: 2
- Views: 17702
Re: Migration from SQL Server to Vertica
Hi Vittalkini,
Vertica doesnt support Stored procedures, Triggers , Packages.
You can only transfer the database objects like Tables and Views from MSSQL to Vertica.
Thanks,
Raj
Vertica doesnt support Stored procedures, Triggers , Packages.
You can only transfer the database objects like Tables and Views from MSSQL to Vertica.
Thanks,
Raj
- Fri Jun 07, 2013 1:26 pm
- Forum: Vertica Database Administration
- Topic: User with dbadmin role cannot drop another user
- Replies: 2
- Views: 5945
Re: User with dbadmin role cannot drop another user
Jim, Ya.. This is working fine... Thanks for your reply.. :) Got one more issue!! Now i logged in with the user 'X' Which i created earlier and granted & set dbadmin Role .. I have a table EMP_Details in the public schema. Now i want to Grant select permission on the table EMP_DETAILS To the New use...
- Fri Jun 07, 2013 12:01 pm
- Forum: Vertica SQL
- Topic: How to simulate Subqueries in the ON Clause in Vertica
- Replies: 8
- Views: 18799
Re: How to simulate Subqueries in the ON Clause in Vertica
Hi Adrian.Opera, I observed that , you haven't used the Alias names for any of the tables you used in the query. But i think, it is better to use the Alias names, as it reduces the code length. Please let me know , if there is any advantage of not using the alias names for the tables. Thank you, Raj..