Search found 29 matches
- Tue Mar 12, 2013 7:17 pm
- Forum: Vertica Database Administration
- Topic: GRANT ON ALL TABLES IN SCHEMA
- Replies: 4
- Views: 14250
Re: GRANT ON ALL TABLES IN SCHEMA
You can just script it out in older versions. I think I got this little script off this forum. dbadmin=> \o grants.sql dbadmin=> select 'grant select on v_schema1.' || table_name || ' to v_main_use;' from tables where table_schema = 'v_schema1'; dbadmin=> \o dbadmin=> \i grants.sql If you use a GUI ...
- Tue Mar 05, 2013 9:40 pm
- Forum: Vertica Database Administration
- Topic: High Volume Web Service and Microstrategy Report... Support
- Replies: 0
- Views: 3992
High Volume Web Service and Microstrategy Report... Support
Currently our Vertica cluster supports Microstrategy reporting. We cache around 110 intelligent cubes overnight during an allocated window where we've finished loading data for the day and build aggregation tables to support various products within Microstrategy. I've built out a new table designed ...
- Mon Feb 25, 2013 5:12 pm
- Forum: Vertica SQL
- Topic: Crosstab or Pivot Function
- Replies: 2
- Views: 12002
Re: Crosstab or Pivot Function
Forgot about some code I wrote a long time ago on MS SQL to perform the crosstab before I learned about the keyword. Works quickly and sets us up to use a left join on a subquery so I think I sorted this out. Here's the code, masked again of course so forgive me if it doesn't tie back to my previous...
- Sat Feb 23, 2013 12:12 am
- Forum: Vertica SQL
- Topic: Crosstab or Pivot Function
- Replies: 2
- Views: 12002
Crosstab or Pivot Function
Let me start off by saying I can express my requirements using SQL... however it is slow. In MS SQL there existed the PIVOT function where you could define a grouping, join to a table with many records associated with the grouping and shift these values into columns. I'll apologize for the poor setu...
- Fri Jan 25, 2013 12:19 am
- Forum: Vertica SQL
- Topic: quote_ident() behavior issue
- Replies: 2
- Views: 6104
Re: quote_ident() behavior issue
This solution was provided to me on the vertica forums: ------------------------- The QUOTE_IDENT function only adds quote if required, i.e., id the string is a vertica keyword or has special characters. Looks like your requirement is to enclose all strings with quotes. A quick workaround is to appe...
- Thu Jan 24, 2013 11:49 pm
- Forum: Vertica SQL
- Topic: quote_ident() behavior issue
- Replies: 2
- Views: 6104
quote_ident() behavior issue
Most likely the issue here is my lack of understanding but here's the issue: We're selecting a series of records from a table in an export in attempt to fake a JSON object (you know, DBAs do the backbending). General layout being: {_id:<value>, Attribute1: {Detail1:<value>, Detail2: <value>}, Attrib...
- Thu Jan 24, 2013 11:27 pm
- Forum: Vertica Database Development
- Topic: Cannot Update / Slow Update
- Replies: 12
- Views: 43080
Re: Cannot Update / Slow Update
The complete re-design has helped quite a bit. Data load window is back down to under an hour for 20 GBs of data files. For the interim I had to comment out the update records and just stack those up in a temp table for later actioning. Since then any query specific design sessions have not been aut...