× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ranarohitp(*) reported 2013-08-12T13:05:32Z  · last modified 2013-08-23T07:49:06Z

Include PARTITION BY on tables


Dev
Fun Fun
funfun
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component DB - Aster 5.x
Version 14.0
Aqua Data Studio 14.0.0-beta-80
Database Version: Aster n Cluster 5.x
 
According to documentation of Aster table data can be partitioned on either Range or List , but ADS GUI have no such provision to do so.
Use the following create script to create table using query analyzer window and table will be created.
 
CREATE FACT TABLE trans( id int, country varchar, ts timestamp )
  DISTRIBUTE BY HASH(id)
  PARTITION BY RANGE(ts) (
PARTITION oldrecords( END '2011-01-01' ), -- everything pre-2011
PARTITION jan01_2011( END '2011-01-02' ),
PARTITION jan02_2011( END '2011-01-03' ),
PARTITION jan03_2011( END '2011-01-04' )
);
2 attachments

Issue #9758

Closed
Fixed
Resolved 2013-08-16T22:18:30Z
 
 
Completion
No due date
Fixed Build 14.0.0-beta-87/15.0.0-dev-8
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017