vertica_开发者

Optimizing a Vertica SQL query to do running totals

I have a table S with time series data like this: keydaydelta For a given key, it\'s possible but unlikely that days will be missing.[详细]

2023-03-25 05:16 分类：问答

Creating WCF DataService with database other than SQL Server

We would like to expose data we have residing in a Vertica database via the WCF Data Services.(Ultimately, we want to access the data in Excel\'s pivot t开发者_运维百科ables features, and I\'ve create[详细]

2023-02-19 03:10 分类：问答

How to escape quotes in strings in vertica (vsql)?

So I need to insert some values开发者_如何学Python into a vertica database (via vsql), which may contain quotes and all sorts of special characters. But vertica does not seem to understand character e[详细]

2023-02-13 01:54 分类：问答

Column store on top of hadoop?

Is there a column store similar to Vertica that is built on top of Hadoop.. I am not talking about HBase as it is spa开发者_StackOverflowrse matrix store and can not get the level of compression that[详细]

2023-02-04 10:32 分类：问答

In Django, queries are generated with "::text" casting, how can I turn that off?

SELECT \"snore_notification\".\"id\", \"snore_notification\".\"acknowledged\", \"snore_notification\".\"active\", \"snore_notification\".\"classname\",[详细]

2023-02-02 01:28 分类：问答

Using an ODBC application with a JDBC driver

My company uses Vertica. 开发者_开发百科 We have Python applications that connect to it with pyodbc.I do most of my development on a Mac (Snow Leopard) and unfortunately Vertica has not released ODBC[详细]

2022-12-28 01:58 分类：问答

How do I Put Several Select Statements into Different Columns

I basically have 7 select statements that I need to have the results output into separate columns.Normally I would use a crosstab for this but I need a fast efficient way to go about this as there are[详细]

2022-12-23 04:30 分类：问答

Is there a "Force Index" equivalent in Vertica?

Is there a \"Force Index\" from My开发者_如何学PythonSQL equivalent in Vertica DB?You can select directly from a projection instead of the table.For instance, instead of[详细]

2022-12-19 13:17 分类：问答

Datawarehouse duplicate dimension rows

We\'re starting to load up a datawarehouse with data from event logs.We have a normal star schema where a row in the fact table represents one event.Our di开发者_JS百科mension tables are a typical com[详细]

2022-12-11 11:06 分类：问答