I want to index a mysql .The table is named as "date+topic",for example 20170601_action ,however ,the column time in table is in format "hh:mm:ss",so,HOW could I index it with date+time as timestamp?
Create a custom view in the DB that is rearranged appropriately and then access the table's data indirectly through that view.
are you using DB connect or a custom ETL?