Archives of the TeradataForum

Message Posted: Thu, 29 Jan 2015 @ 12:23:41 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Unfortunately it's a little more complicated than just a "simple" grouping. Here is a sample SHOW output..

     COLLECT STATISTICS
                 COLUMN ( FinanceNumber ) ,
                 COLUMN ( LaborCode2 ) ,
                 COLUMN ( DesignationActivityCode ) ,
                 COLUMN ( TADate ) ,
                 COLUMN ( StartTime ) ,
                 COLUMN ( StartTimeDecimal ) ,
                 COLUMN ( StartDate ) ,
                 COLUMN ( OperationID ) ,
                 COLUMN ( WeekID ) ,
                 COLUMN ( EmpID ) ,
                 COLUMN ( EmpID ,WeekID ,TADate ) ,
                 COLUMN ( WeekID ,TADate ,FinanceNumber ) ,
                 COLUMN ( WeekID ,TADate ,LaborCode2 ) ,
                 COLUMN ( EmpID ,TADate ) ,
                 COLUMN ( TADate ,LaborCode2 ) ,
                 COLUMN ( EmpID ,WeekID ) ,
                 COLUMN ( WeekID ,FinanceNumber ) ,
                 COLUMN ( WeekID ,OperationID ) ,
                 COLUMN ( TADate ,FinanceNumber ) ,
                 COLUMN ( EmpID ,WeekID ,FinanceNumber ) ,
                 COLUMN ( EmpID ,WeekID ,TADate ,FinanceNumber ) ,
                 COLUMN ( LaborCode2 ,FinanceNumber ) ,
                 COLUMN ( EmpID ,TADate ,LaborCode2 ) ,
                 COLUMN ( EmpID ,TADate ,FinanceNumber )
                     ON edwacctngprod.TACSStartTimeOperActuals ; COLLECT STATISTICS
                  USING MAXVALUELENGTH 40
                 COLUMN ( EmpID ,WeekID ,OperationID ,LocalUnitID ,TADate,DesignationActivityCode
                            ,LaborCode2 ,FinanceNumber ,RouteNumber ,RouteNumber3 )
                     ON edwacctngprod.TACSStartTimeOperActuals ; COLLECT STATISTICS
                  USING SYSTEM SAMPLE
                        AND MAXVALUELENGTH 35
                 COLUMN ( EmpID ,StartDTM ,WeekID ,OperationID ,LocalUnitID )
                     ON edwacctngprod.TACSStartTimeOperActuals ;

Bob Briggs TDCM
Teradata Certified Master
EDW Infrastructure and Operations Group
USPS

	<Prev	Next>		<<First	<Prev	Next>	Last>>