File structure cannot be determined. illegal_argument_exception

Hi Elastic Community, I am new to Kibana and Elastic. I am following the official Elastic tutorial. In the demonstration, a file was uploaded to Data Visualizer, which was analyzed successfully, but I got the following error when I tried the same.

""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
The file structure cannot be determined. illegal_argument_exception
The explanation so far:

[Using character encoding [UTF-8], which matched the input with [15%] confidence - first [8kB] of input was pure ASCII]

""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""

I have also checked the file in an online JSON validator which confirmed that the file is correct. The full file contains almost 200k lines. I am sharing few lines as a sample here:

[
{"category": "CRIME", "headline": "There Were 2 Mass Shootings In Texas Last Week, But Only 1 On TV", "authors": "Melissa Jeltsen", "link": "https://www.huffingtonpost.com/entry/texas-amanda-painter-mass-shooting_us_5b081ab4e4b0802d69caad89", "short_description": "She left her husband. He killed their children. Just another day in America.", "date": "2018-05-26"},
{"category": "ENTERTAINMENT", "headline": "Will Smith Joins Diplo And Nicky Jam For The 2018 World Cup's Official Song", "authors": "Andy McDonald", "link": "https://www.huffingtonpost.com/entry/will-smith-joins-diplo-and-nicky-jam-for-the-official-2018-world-cup-song_us_5b09726fe4b0fdb2aa541201", "short_description": "Of course it has a song.", "date": "2018-05-26"},
{"category": "ENTERTAINMENT", "headline": "Hugh Grant Marries For The First Time At Age 57", "authors": "Ron Dicker", "link": "https://www.huffingtonpost.com/entry/hugh-grant-marries_us_5b09212ce4b0568a880b9a8c", "short_description": "The actor and his longtime girlfriend Anna Eberstein tied the knot in a civil ceremony.", "date": "2018-05-26"},
{"category": "ENTERTAINMENT", "headline": "Jim Carrey Blasts 'Castrato' Adam Schiff And Democrats In New Artwork", "authors": "Ron Dicker", "link": "https://www.huffingtonpost.com/entry/jim-carrey-adam-schiff-democrats_us_5b0950e8e4b0fdb2aa53e675", "short_description": "The actor gives Dems an ass-kicking for not fighting hard enough against Donald Trump.", "date": "2018-05-26"},
{"category": "ENTERTAINMENT", "headline": "Julianna Margulies Uses Donald Trump Poop Bags To Pick Up After Her Dog", "authors": "Ron Dicker", "link": "https://www.huffingtonpost.com/entry/julianna-margulies-trump-poop-bag_us_5b093ec2e4b0fdb2aa53df70", "short_description": "The "Dietland" actress said using the bags is a "really cathartic, therapeutic moment."", "date": "2018-05-26"},
{"category": "ENTERTAINMENT", "headline": "Morgan Freeman 'Devastated' That Sexual Harassment Claims Could Undermine Legacy", "authors": "Ron Dicker", "link": "https://www.huffingtonpost.com/entry/morgan-freeman-devastated-sexual-misconduct_us_5b096319e4b0802d69cba298", "short_description": ""It is not right to equate horrific incidents of sexual assault with misplaced compliments or humor," he said in a statement.", "date": "2018-05-26"},
{"category": "ENTERTAINMENT", "headline": "Donald Trump Is Lovin' New McDonald's Jingle In 'Tonight Show' Bit", "authors": "Ron Dicker", "link": "https://www.huffingtonpost.com/entry/donald-trump-mcondalds-tonight-show_us_5b093561e4b0fdb2aa53daba", "short_description": "It's catchy, all right.", "date": "2018-05-26"},
{"category": "ENTERTAINMENT", "headline": "What To Watch On Amazon Prime That\u2019s New This Week", "authors": "Todd Van Luling", "link": "https://www.huffingtonpost.com/entry/amazon-prime-what-to-watch_us_5b044625e4b0c0b8b23ec14f", "short_description": "There's a great mini-series joining this week.", "date": "2018-05-26"},
{"category": "ENTERTAINMENT", "headline": "Mike Myers Reveals He'd 'Like To' Do A Fourth Austin Powers Film", "authors": "Andy McDonald", "link": "https://www.huffingtonpost.com/entry/mike-myers-reveals-he-wants-to-do-a-fourth-austin-powers-film_us_5b096198e4b0802d69cb9f15", "short_description": "Myer's kids may be pushing for a new "Powers" film more than anyone.", "date": "2018-05-26"},
{"category": "ENTERTAINMENT", "headline": "What To Watch On Hulu That\u2019s New This Week", "authors": "Todd Van Luling", "link": "https://www.huffingtonpost.com/entry/hulu-what-to-watch_us_5b0445bae4b0c0b8b23ec046", "short_description": "You're getting a recent Academy Award-winning movie.", "date": "2018-05-26"},
{"category": "ENTERTAINMENT", "headline": "Justin Timberlake Visits Texas School Shooting Victims", "authors": "Sebastian Murdock", "link": "https://www.huffingtonpost.com/entry/justin-timberlake-visits-texas-school-shooting-victims_us_5b098161e4b0fdb2aa54167e", "short_description": "The pop star also wore a "Santa Fe Strong" shirt at his show in Houston.", "date": "2018-05-26"},
{"category": "WORLD NEWS", "headline": "South Korean President Meets North Korea's Kim Jong Un To Talk Trump Summit", "authors": "", "link": "https://www.huffingtonpost.com/entry/south-korean-president-meets-north-koreas-kim-jong-un_us_5b094ebae4b0fdb2aa53e504", "short_description": "The two met to pave the way for a summit between North Korean and the U.S.", "date": "2018-05-26"},
{"category": "IMPACT", "headline": "With Its Way Of Life At Risk, This Remote Oyster-Growing Region Called In Robots", "authors": "Karen Pinchin", "link": "https://www.huffingtonpost.com/entry/remote-oyster-growing-region-called-in-robots_us_5b083658e4b0fdb2aa53415d", "short_description": "The revolution is coming to rural New Brunswick.", "date": "2018-05-26"},
{"category": "POLITICS", "headline": "Trump's Crackdown On Immigrant Parents Puts More Kids In An Already Strained System", "authors": "Elise Foley and Roque Planas", "link": "https://www.huffingtonpost.com/entry/immigrant-children-separated-from-parents_us_5b087b90e4b0802d69cb4070", "short_description": "Last month a Health and Human Services official revealed the government was unable to locate nearly 1,500 children who had been released from its custody.", "date": "2018-05-26"},
{"category": "POLITICS", "headline": "'Trump's Son Should Be Concerned': FBI Obtained Wiretaps Of Putin Ally Who Met With Trump Jr.", "authors": "Michael Isikoff, Yahoo News", "link": "https://www.huffingtonpost.com/entry/fbi-wiretaps-putin-ally-trump-jr_us_5b08bf56e4b0568a880b7859", "short_description": "The wiretaps feature conversations between Alexander Torshin and Alexander Romanov, a convicted Russian money launderer.", "date": "2018-05-26"},
{"category": "POLITICS", "headline": "Edward Snowden: There's No One Trump Loves More Than Vladimir Putin", "authors": "Mary Papenfuss", "link": "https://www.huffingtonpost.com/entry/edward-snowden-trump-loves-putin_us_5b08ae41e4b0568a880b7451", "short_description": "But don't count on Robert Mueller to nail him, the NSA whistleblower warns.", "date": "2018-05-26"}
]

The original file didn't have [ ] square brackets at start and end. This was an error when I checked JSON online which was removed after adding [ ] square brackets at start and end.

I have also tried to upload file without date field but still getting error. Any help in this regard would be highly appreciated.
Happy Learning :slight_smile:

Hi, an online JSON validator will check the syntax for valid JSON, but the Data Visualizer in Machine Learning expects the data to be CSV or NDJSON.

The file should have multiple JSON documents separated by newlines. Your file has a single JSON array with multiple items.

If I change your sample to this and fix other problems you have with unescaped quotes, it becomes usable in the Data Visualizer:

{"category": "CRIME", "headline": "There Were 2 Mass Shootings In Texas Last Week, But Only 1 On TV", "authors": "Melissa Jeltsen", "link": "https://www.huffingtonpost.com/entry/texas-amanda-painter-mass-shooting_us_5b081ab4e4b0802d69caad89", "short_description": "She left her husband. He killed their children. Just another day in America.", "date": "2018-05-26"}
{"category": "ENTERTAINMENT", "headline": "Will Smith Joins Diplo And Nicky Jam For The 2018 World Cup's Official Song", "authors": "Andy McDonald", "link": "https://www.huffingtonpost.com/entry/will-smith-joins-diplo-and-nicky-jam-for-the-official-2018-world-cup-song_us_5b09726fe4b0fdb2aa541201", "short_description": "Of course it has a song.", "date": "2018-05-26"}
{"category": "ENTERTAINMENT", "headline": "Hugh Grant Marries For The First Time At Age 57", "authors": "Ron Dicker", "link": "https://www.huffingtonpost.com/entry/hugh-grant-marries_us_5b09212ce4b0568a880b9a8c", "short_description": "The actor and his longtime girlfriend Anna Eberstein tied the knot in a civil ceremony.", "date": "2018-05-26"}
{"category": "ENTERTAINMENT", "headline": "Jim Carrey Blasts 'Castrato' Adam Schiff And Democrats In New Artwork", "authors": "Ron Dicker", "link": "https://www.huffingtonpost.com/entry/jim-carrey-adam-schiff-democrats_us_5b0950e8e4b0fdb2aa53e675", "short_description": "The actor gives Dems an ass-kicking for not fighting hard enough against Donald Trump.", "date": "2018-05-26"}
{"category": "ENTERTAINMENT", "headline": "Julianna Margulies Uses Donald Trump Poop Bags To Pick Up After Her Dog", "authors": "Ron Dicker", "link": "https://www.huffingtonpost.com/entry/julianna-margulies-trump-poop-bag_us_5b093ec2e4b0fdb2aa53df70", "short_description": "The \"Dietland\" actress said using the bags is a \"really cathartic, therapeutic moment.\"", "date": "2018-05-26"}
{"category": "ENTERTAINMENT", "headline": "Morgan Freeman 'Devastated' That Sexual Harassment Claims Could Undermine Legacy", "authors": "Ron Dicker", "link": "https://www.huffingtonpost.com/entry/morgan-freeman-devastated-sexual-misconduct_us_5b096319e4b0802d69cba298", "short_description": "\"It is not right to equate horrific incidents of sexual assault with misplaced compliments or humor,\" he said in a statement.", "date": "2018-05-26"}
{"category": "ENTERTAINMENT", "headline": "Donald Trump Is Lovin' New McDonald's Jingle In 'Tonight Show' Bit", "authors": "Ron Dicker", "link": "https://www.huffingtonpost.com/entry/donald-trump-mcondalds-tonight-show_us_5b093561e4b0fdb2aa53daba", "short_description": "It's catchy, all right.", "date": "2018-05-26"}
{"category": "ENTERTAINMENT", "headline": "What To Watch On Amazon Prime That\u2019s New This Week", "authors": "Todd Van Luling", "link": "https://www.huffingtonpost.com/entry/amazon-prime-what-to-watch_us_5b044625e4b0c0b8b23ec14f", "short_description": "There's a great mini-series joining this week.", "date": "2018-05-26"}
{"category": "ENTERTAINMENT", "headline": "Mike Myers Reveals He'd 'Like To' Do A Fourth Austin Powers Film", "authors": "Andy McDonald", "link": "https://www.huffingtonpost.com/entry/mike-myers-reveals-he-wants-to-do-a-fourth-austin-powers-film_us_5b096198e4b0802d69cb9f15", "short_description": "Myer's kids may be pushing for a new \"Powers\" film more than anyone.", "date": "2018-05-26"}
{"category": "ENTERTAINMENT", "headline": "What To Watch On Hulu That\u2019s New This Week", "authors": "Todd Van Luling", "link": "https://www.huffingtonpost.com/entry/hulu-what-to-watch_us_5b0445bae4b0c0b8b23ec046", "short_description": "You're getting a recent Academy Award-winning movie.", "date": "2018-05-26"}
{"category": "ENTERTAINMENT", "headline": "Justin Timberlake Visits Texas School Shooting Victims", "authors": "Sebastian Murdock", "link": "https://www.huffingtonpost.com/entry/justin-timberlake-visits-texas-school-shooting-victims_us_5b098161e4b0fdb2aa54167e", "short_description": "The pop star also wore a \"Santa Fe Strong\" shirt at his show in Houston.", "date": "2018-05-26"}
{"category": "WORLD NEWS", "headline": "South Korean President Meets North Korea's Kim Jong Un To Talk Trump Summit", "authors": "", "link": "https://www.huffingtonpost.com/entry/south-korean-president-meets-north-koreas-kim-jong-un_us_5b094ebae4b0fdb2aa53e504", "short_description": "The two met to pave the way for a summit between North Korean and the U.S.", "date": "2018-05-26"}
{"category": "IMPACT", "headline": "With Its Way Of Life At Risk, This Remote Oyster-Growing Region Called In Robots", "authors": "Karen Pinchin", "link": "https://www.huffingtonpost.com/entry/remote-oyster-growing-region-called-in-robots_us_5b083658e4b0fdb2aa53415d", "short_description": "The revolution is coming to rural New Brunswick.", "date": "2018-05-26"}
{"category": "POLITICS", "headline": "Trump's Crackdown On Immigrant Parents Puts More Kids In An Already Strained System", "authors": "Elise Foley and Roque Planas", "link": "https://www.huffingtonpost.com/entry/immigrant-children-separated-from-parents_us_5b087b90e4b0802d69cb4070", "short_description": "Last month a Health and Human Services official revealed the government was unable to locate nearly 1,500 children who had been released from its custody.", "date": "2018-05-26"}
{"category": "POLITICS", "headline": "'Trump's Son Should Be Concerned': FBI Obtained Wiretaps Of Putin Ally Who Met With Trump Jr.", "authors": "Michael Isikoff, Yahoo News", "link": "https://www.huffingtonpost.com/entry/fbi-wiretaps-putin-ally-trump-jr_us_5b08bf56e4b0568a880b7859", "short_description": "The wiretaps feature conversations between Alexander Torshin and Alexander Romanov, a convicted Russian money launderer.", "date": "2018-05-26"}
{"category": "POLITICS", "headline": "Edward Snowden: There's No One Trump Loves More Than Vladimir Putin", "authors": "Mary Papenfuss", "link": "https://www.huffingtonpost.com/entry/edward-snowden-trump-loves-putin_us_5b08ae41e4b0568a880b7451", "short_description": "But don't count on Robert Mueller to nail him, the NSA whistleblower warns.", "date": "2018-05-26"}

1 Like

Hi @tsullivan ... Thank You very much... It's really working now.. I was stuck for few days and you pull me out of this situation... Now I can start my learning... Thanks again :slight_smile: