I am trying to put a hive table above a wooden roof table made of the following JSN material:
"": "", "Provider": "[4]": "", "Provider": [{"id": "4220", "name": "dbmvl", "behaviors": {"B1": "gxybq", "b2": "ntfmx" "id": "4173", "name": "dvjke", "behaviors": {"b1": "sizow", "b2": " Knuuc "}"} user_id ":" 3960 "," providers ": [{" id ":" 1859 "," name ":" ponsv "," behavior ": {" b 1 ":" ahfgc "," b2 ":" txpea "}}, {" id ":" 103 "," name ":" uhqqo "," behaviors ": {" b1 ":" lktyo "," b2 ":" Ituxy "}}}}
" user_id ":" 567 "," providers ": [{" id ":" 9622 "," name ":" crjju "," behavior ": {"B1": "": "B1": "eipse", "b2": "r2q", "b2": "b2": "npnot",} "{{id}:" 6965 "," name ":" fnheh "," behaviors " Nvxqk "}}}}
I used Spark SQL to read json and write a wooden roof file.
On top of the wooden roof file I produced I'm running into problems by hive hav IP: string, name: string, behavior: mapp & lt; String, string & gt; & Gt; & Gt; Make table test (Mycollo STRUCT & lt; user_id: string, provider: ARRAY & lt; STRUCT & lt; id: string, name: string, spelling: & gt; & gt;; & gt;) as a wooden roof Archived; Set the table test Change the location 'HDFF: ///tmp/test.parquet'; Perform the above statement exactly, but when I try to do a selection * on the table I get errors: with the exception failed: java.io.IOException: java.lang.IllegalStateException: Columns mycol index 0 does try to change your query in {Providers = providers, user_id = user_id}
: Testing of the table (user_id: string, provider: ARRAY & lt; STRUCT & lt; id: string, name: string, behavior: map & lt; string, string & gt; & gt; & gt; ;) Stored in a wooden roof;
The root JSON object is flat out when the wooden roof file is stored.
No comments:
Post a Comment