Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 26 Jul 2007 @ 14:52:58 GMT


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


Subj:   Re: View statistic values
 
From:   Frei Daniel

thanks all for your replays

With now decimal(18,0) cast or with the cast by every NumValueswN I get also the invalid date error. When i exclude this columns, then i get a result. But im not sure if everything is correct. Here is the output:

     DatabaseName TableName ColumnName ColumnCount StatsType StatsVersion
     SampleSize NumRows  NumValues NumNulls ModeFreq
     kurs_db      dropme    d          1           C         2            100
     1.23E+18 1         0.00E+00 1
     kurs_db      dropme    i          1           C         2            100
     1        1         0.00E+00 1
     kurs_db      dropme    ts         1           C         2            100
     1        1         0.00E+00 0.00E+00

I created the table and inserted the timestamps, here is the output from the select:

     ColumnName STATisticts
     D707071A0A08386302000000000000000000000000000000010000000000000020043600
     D7070719151800000000000020043600D70707191518000000000000000000000000F03F
     000000000000F03F
     d
     D707071A0A08393402000000000000000000000000000000010001000000000081E97DF4
     1022B14381E97DF41022B143000000000000F03F000000000000F03F000000000000F03F
     81E97DF41022B143
     i
     D707071A0A083A0002000000000000000000000000000000010001000000000000000000
     0000F03F000000000000F03F000000000000F03F000000000000F03F000000000000F03F
     000000000000F03F

its not exactly the same what you get.


thanks for your help.

Dani



     
  <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: 28 Jun 2020