Search found 29 matches

by ncreekmur
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 ...
by ncreekmur
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 ...
by ncreekmur
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...
by ncreekmur
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...
by ncreekmur
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...
by ncreekmur
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...
by ncreekmur
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...

Go to advanced search