Load infile query does't work giving Execute Query: ERROR [HY000] [MySQL][ODBC 8.0(a) Driver][mysqld-5.6.16]The used command is not allowed with this MySQL version

Help Studio
,
1

my query is

LOAD DATA LOCAL INFILE ‘E:\ui_path\AMS\ams_report.csv’ INTO TABLE automation.lotus_raw FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘"’ LINES TERMINATED BY ‘\n’ IGNORE 1 LINES (Date,Portfolio name, Currency, Campaign Name,Ad Group Name, Targeting, Match Type, Impressions, Clicks, Click-Thru Rate (CTR), Cost Per Click (CPC), Spend, Total Advertising Cost of Sales (ACoS), Total Return on Advertising Spend (RoAS), 14 Day Total Sales, 14 Day Total Orders,14 Day Total Units,14 Day Conversion Rate)

please help

2

other queries are working well except this one
i check query on db as well running well there
please help if anyone has any idea

3

Hi, This is more of a MySQL issue. Check this out: sql - ERROR 1148: The used command is not allowed with this MySQL version - Stack Overflow

4

it is already on but still it doesnt work
please suggest some other solution