What is wrong with TSLOAD - dealing with Date formats

the raw data file is in this format - 1/28/2017; 1/14/2017

the tsload command has --date_time_format '%m/%d/%Y'

The target column is declared as "DATETIME"

The TSLOAD is always so buggy :)

Error:

line no=87789 ;Reason: Conversion failed, error=Can not convert "Period" to date using date format "%m/%d/%Y", data column=3, schema column=Period

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Lokesh - it's not clear from your question if you have two dates or not.  Is "1/28/2017; 1/14/2017" all in the same column?  Because that is two dates and would not match your pattern, which would be expecting just "1/28/2017", for example. 

    Also, I'd suggest having this column be a DATE and not DATETIME if you aren't going to be putting times in the data.  It will make things easier with formatting.  

    Reply Like 1
Like Follow
  • 1 yr agoLast active
  • 1Replies
  • 342Views
  • 2 Following