Invalid datetime error in TS UI

Hi All,

 

I tried loading data using ThoughtSpot UI and TSLOAD/TQL – while both data load works fine without any ERROR but I can’t see value of any DATE type field, it shows as INVALID DATETIME in TS UI.

 

Am also able to query it from FALCON database. Attached are screenshots for TQL query and TS UI

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • it doesn't look like DATETIME data. It looks like it is only a DATE field. 

    have you tried changing the data type to DATE instead of DATETIME? 

    Reply Like
  • Hi Marc,

    I never specified DATETIME , I only specified DATE while loading the data

    Reply Like
  • Chhaya Vishwakarma in the columns tab, does it say the data type is date? 

    you could also try setting the format pattern for the date field in the columns tab. 

    Reply Like
  • tried it, don't see any effect PFA screenshot . Do i need to do something to refresh data after changes ?

    Reply Like
Like Follow
  • 6 days agoLast active
  • 4Replies
  • 11Views
  • 2 Following