All Apps and Add-ons

how to index a mysql without datetime

scqing
Engager

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?

Tags (2)
0 Karma

woodcock
Esteemed Legend

Create a custom view in the DB that is rearranged appropriately and then access the table's data indirectly through that view.

0 Karma

jkat54
SplunkTrust
SplunkTrust

are you using DB connect or a custom ETL?

0 Karma
Get Updates on the Splunk Community!

Get ready to show some Splunk Certification swagger at .conf24!

Dive into the deep end of data by earning a Splunk Certification at .conf24. We're enticing you again this ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Now On-Demand Join us to learn more about how you can leverage Service Level Objectives (SLOs) and the new ...

Database Performance Sidebar Panel Now on APM Database Query Performance & Service ...

We’ve streamlined the troubleshooting experience for database-related service issues by adding a database ...