Yes, I got the same problem! Perhaps the parser is not considering convert the alias from SQL to SPL, I think...
SELECT user as username FROM mysql.user WHERE user='root';
I am having a same problem as well with using the 'AS' in select statement.
You cannot join multiple tables that has same column names if you cant
use the AS.
I hope there is a solution for this.
Do not be resolved in a way and a separate column by editing the column?
| dbquery mysql01 limit=1000 "select users.id+0 as user_id from users"
How about now?
SELECT DISTINCT issuestatus.pname+"" AS "Status" FROM issuestatus
I think I found the root cause of this problem in the README notes for MySQL J connector 5.1.x which states that .getColumnName() now always returns the original column name and the caller must use .getColumnLabel() to get the alias.
Downgrading from 5.1.4 to 3.14 solved the problem for me, although I'm sure it will cause other problems down the road. I have reported the issue to Splunk via our dealer.
If this is in the Database Input or Database Query feature - I found a workaround for this. Simply cast all the fields and it should work.
SELECT DISTINCT CAST(issuestatus.pname AS Char(32)) AS Status FROM issuestatus