Insert into Hive avro table

2017-01-13 Thread infa elance
Im trying to insert into hive avro table from a hive text table and getting the following error. Error: Error while compiling statement: FAILED: SemanticException [Error 10044]: Line 1:23 Cannot insert into target table because column number/types are different 'member_poc_avro': Cannot convert

Re: Adding a Hive Statement of SQL Conformance to the docs

2017-01-13 Thread Alan Gates
+1. I think this will be great for existing and potential Hive users. Alan. > On Jan 13, 2017, at 9:09 AM, Carter Shanklin wrote: > > I get asked from time to time what Hive's level of SQL conformance is, and > it's difficult to provide a clean answer. Most SQL

Adding a Hive Statement of SQL Conformance to the docs

2017-01-13 Thread Carter Shanklin
I get asked from time to time what Hive's level of SQL conformance is, and it's difficult to provide a clean answer. Most SQL systems have some detailed statement of SQL conformance to help answer this question. For a year or so I've maintained a spreadsheet that tracks Hive's SQL conformance,