Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 24 Mar 2004 @ 20:39:55 GMT


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


Subj:   Syntax Error - Join Index
 
From:   Jackson Price

Hi, all -

I'm getting a syntax error in the following DDL for a simple join index.

CREATE JOIN INDEX j1 AS

SELECT
prod_key,
cust_key,
sum(dw_qty)

FROM cfs_prodata_db.fact_gl_trans_test

WHERE region_key in(1,2,3,4,5,6,7,8)

GROUP BY   prod_key, cust_key ;

The error is:

"Error in join index DDL. Only columns, EXTRACT, SUM, or COUNT expressions are allowed in select list."


The select list DOES contain only those items.

Any ideas?


Thanks in advance.

Jackson

Jackson Price
American Red Cross
Data Warehouse & Decision Support Systems



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023