Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 1EBD418AF1 for ; Thu, 3 Mar 2016 22:05:34 +0000 (UTC) Received: (qmail 18023 invoked by uid 500); 3 Mar 2016 22:05:27 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 17952 invoked by uid 500); 3 Mar 2016 22:05:27 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 17942 invoked by uid 99); 3 Mar 2016 22:05:27 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Mar 2016 22:05:27 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id DFB551804BB for ; Thu, 3 Mar 2016 22:05:26 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.198 X-Spam-Level: ** X-Spam-Status: No, score=2.198 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_REPLY=1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id RTUcv-wPwtfi for ; Thu, 3 Mar 2016 22:05:22 +0000 (UTC) Received: from mail-ob0-f175.google.com (mail-ob0-f175.google.com [209.85.214.175]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 9CE3C5F3F1 for ; Thu, 3 Mar 2016 22:05:21 +0000 (UTC) Received: by mail-ob0-f175.google.com with SMTP id rt7so33486777obb.3 for ; Thu, 03 Mar 2016 14:05:21 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to; bh=wQH+LWiRVD8YDds3nQztt80TiI7lqaPMOOfhVeVnFWk=; b=yfCt1IojbcpkEUJovvQ4iu7uf5/JvQTQKMzqAn6WOyzXJrJXec9XtaxqcUvbnNFzl8 q1hwL07CQMffIIibjJfX9YK94xllxih+IdonFANOdYLA51/Ye9uPA6chcGHKkzKkusJj m2Z4mb0WAsM2eI7Op4i4W3dVXNlU910TDcvIdB9ThS9nABinr9LNEP1azoDwvmgYvPXL /zfa/Y0KZ3j/H8tF0tCt9Ia4jvHc2PL72lAxO3EbdtrZbzDxSz7uJP4CynnsbC+2EhgE KB9ewmhew0CW3U6gC1axkdWGFm6YgsYsHMgcmUgFTaJD3UKBMuPdg416q5QsZRnoAgnj ZlfA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to; bh=wQH+LWiRVD8YDds3nQztt80TiI7lqaPMOOfhVeVnFWk=; b=LqcgTFkQB2tbFo1pX022EfHljqRpvwlcOrF4F18xu3JeSQ4k+t3TpYcgpX9in6NTyU Uhvg2lm7IyT5n2jiOKe7UDOm2KY3nnz0sVzRLD5qZtZDfol5SmpyxcCP0jP+q/Kf7lax F8rWN3C4+vCpGqrfqhDFiNby6w2tV1/lbLtVdpp5YSKcBlGjoFEN3S4uMZh57QHQ1u9k aSXLkTIBSXUoeAiI5wq6ou9ZHST1UcP17UZ/d9BOg5n5F5U0tVI2Ijtd+TUhh19QNMFN XA9lfdEB330yVZ3QZzIES1kshyUbcUdH9ZmZh11ZtE382xx7gAbWT7PETaEzSBxSjuYy pQHg== X-Gm-Message-State: AD7BkJJNa6cQwsxehcVTueQqmlufuXcz2eW0CuBB70qGedJKBG7AhK8fWneALsXo6lAdC/DMbn5xnWYApS8rSQ== MIME-Version: 1.0 X-Received: by 10.182.108.229 with SMTP id hn5mr3752070obb.75.1457042720420; Thu, 03 Mar 2016 14:05:20 -0800 (PST) Received: by 10.202.201.197 with HTTP; Thu, 3 Mar 2016 14:05:20 -0800 (PST) In-Reply-To: References: Date: Thu, 3 Mar 2016 16:05:20 -0600 Message-ID: Subject: Re: Hive Struct Type Restrictions. From: Kevin Vasko To: user@hive.apache.org Content-Type: multipart/alternative; boundary=089e0149d2bac5fed4052d2c319e --089e0149d2bac5fed4052d2c319e Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I had a similar issue when using Hive and trying to create a 400+ column table. Are you using HDP or have Apache Atlas anywhere in your ecosystem? If so, try disabling Apache Atlas and see if the issue goes away. My issue seemed be related to the fact that the Apache Atlas system was erroring when a really long query was being issued. On Thu, Mar 3, 2016 at 2:02 PM, satyajit vegesna wrote: > > Hi All, > > I am trying to create a table with multiple STRUCT column types, one of > which having more than 300 fields. > > I get the table created with no problem, but when i load i face few error= s > in loading up the data.when i check SHOW CREATE TABLE TABLENAME, i get > fields only till 266th column and rest of them do not appear in the table > DDL. > > Would like to know, if there is any restriction on the number of fields t= o > be using in STRUCT datatype. > > EXAMPLE: > > BELOW IS THE DDL i run in hive and the below in red is the TABLE DDL i ge= t > from SHOW CREATE TABLE. > > CREATE TABLE property_feature.property_feature_new( > `_id` STRUCT<`mls_sysid`:String,`type`:String>, > all_attrs STRUCT<`1`: String ,`10`: String ,`100`: String ,`105`: String > ,`113`: String ,`118`: String ,`126`: String ,`1299`: String ,`1301`: > String ,`1305`: String ,`1307`: String ,`1319`: String ,`1325`: String > ,`1327`: String ,`1329`: String ,`1339`: String ,`1341`: String ,`1345`: > String ,`1351`: String ,`1353`: String ,`1359`: String ,`1363`: String > ,`1365`: String ,`1367`: String ,`1373`: String ,`1377`: String ,`1397`: > String ,`1401`: String ,`1403`: String ,`1405`: String ,`1409`: String > ,`1411`: String ,`1413`: String ,`1417`: String ,`1419`: String ,`1421`: > String ,`1423`: String ,`1431`: String ,`1437`: String ,`1439`: String > ,`144`: String ,`1441`: String ,`145`: String ,`1451`: String ,`1453`: > String ,`146`: String ,`1467`: String ,`1469`: String ,`1483`: String > ,`1485`: String ,`1491`: String ,`1493`: String ,`15`: String ,`1505`: > String ,`1519`: String ,`1521`: String ,`1523`: String ,`155`: String > ,`156`: String ,`158`: String ,`1586`: String ,`1678`: String ,`169`: > String ,`17`: String ,`177`: String ,`1783`: String ,`1785`: String > ,`1787`: String ,`1789`: String ,`1793`: String ,`1795`: String ,`1797`: > String ,`1799`: String ,`1801`: String ,`1803`: String ,`1805`: String > ,`1807`: String ,`1809`: String ,`1811`: String ,`1815`: String ,`1818`: > String ,`1826`: String ,`1829`: String ,`1874`: String ,`1876`: String > ,`1878`: String ,`1880`: String ,`1882`: String ,`207`: String ,`215`: > String ,`226`: String ,`2293`: String ,`232`: String ,`239`: String ,`241= `: > String ,`245`: String ,`2456`: String ,`248`: String ,`2482`: String > ,`2490`: String ,`2491`: String ,`2492`: String ,`2493`: String ,`2495`: > String ,`25`: String ,`2502`: String ,`2503`: String ,`2517`: String > ,`2522`: String ,`255`: String ,`256`: String ,`2573`: String ,`2574`: > String ,`260`: String ,`263`: String ,`265`: String ,`276`: String ,`278`= : > String ,`286`: String ,`293`: String ,`296`: String ,`299`: String ,`3`: > String ,`30`: String ,`307`: String ,`312`: String ,`320`: String ,`328`: > String ,`340`: String ,`348`: String ,`354`: String ,`363`: String ,`364`= : > String ,`369`: String ,`375`: String ,`376`: String ,`383`: String ,`401`= : > String ,`405`: String ,`409`: String ,`412`: String ,`42`: String ,`423`: > String ,`444`: String ,`445`: String ,`446`: String ,`447`: String ,`450`= : > String ,`451`: String ,`452`: String ,`453`: String ,`455`: String ,`458`= : > String ,`461`: String ,`463`: String ,`464`: String ,`51`: String > ,`543472980`: String ,`57`: String ,`75`: String ,`90`: String ,`92`: > String ,`AVMYN`: String ,`AccessibilityAmenities`: String ,`AddressPublic= `: > String ,`Amenities`: String ,`AmountofWaterFront`: String > ,`AppliancesIncluded`: String ,`AppraiserInitials`: String > ,`AppraiserName`: String ,`Basement`: String ,`BathsFull`: String > ,`BathsHalf`: String ,`BathsTotal`: String ,`BedsTotal`: String ,`Block`: > String ,`Book`: String ,`BuildingNumber`: String ,`City`: String > ,`CloseDate`: String ,`ClosePrice`: String , > `CoListAgentDirectWorkPhone`: String ,`CoListAgentEmail`: String > ,`CoListAgentFullName`: String ,`CoListAgentMLSID`: String > ,`CoListAgent_MUI`: String ,`CoListOfficeMLSID`: String > ,`CoListOfficeName`: String ,`CoListOfficePhone`: String > ,`CoListOffice_MUI`: String ,`Color`: String ,`CommentsYN`: String > ,`Construction`: String ,`Cooling`: String ,`CountyOrParish`: String > ,`DOM`: String ,`Deed`: String ,`Directions`: String ,`Driveway`: String > ,`Electric`: String ,`Equipment`: String ,`Exterior`: String ,`Fireplace`= : > String ,`FloorNumber`: String ,`Floors`: String ,`FoundationMaterials`: > String ,`FullTaxAmount`: String ,`Gas`: String ,`HeatFuel`: String > ,`HeatSystem`: String ,`Internet`: String ,`ListAgentDirectWorkPhone`: > String ,`ListAgentEmail`: String ,`ListAgentFullName`: String > ,`ListAgentMLSID`: String ,`ListAgent_MUI`: String ,`ListOfficeMLSID`: > String ,`ListOfficeName`: String ,`ListOfficePhone`: String > ,`ListOffice_MUI`: String ,`ListPrice`: String ,`ListingContractDate`: > String ,`Location`: String ,`Lot`: String ,`LotSizeArea`: String > ,`MLSNumber`: String ,`Make`: String ,`MapNumber`: String > ,`MatrixModifiedDT`: String ,`MobileHomeIncludes`: String ,`Model`: Strin= g > ,`MonthlyAssociationFee`: String ,`NeighborhoodAssoc`: String > ,`NumberOfRooms`: String ,`OneBedroomUnits`: String ,`OriginalListPrice`: > String ,`Page`: String ,`Parking`: String ,`PhotoCount`: String > ,`PhotoModificationTimestamp`: String ,`PostalCode`: String > ,`PropertySubType`: String ,`PropertyType`: String ,`PublicAddress`: Stri= ng > ,`RecreationalWater`: String ,`Remarks`: String ,`Restrictions`: String > ,`RoadFrontage`: String ,`Roads`: String ,`Roof`: String ,`SchoolDistrict= `: > String ,`Seasonal`: String ,`SellingAgentDirectWorkPhone`: String > ,`SellingAgentEmail`: String ,`SellingAgentFullName`: String > ,`SellingAgentMLSID`: String ,`SellingAgent_MUI`: String > ,`SellingOfficeMLSID`: String ,`SellingOfficeName`: String > ,`SellingOfficePhone`: String ,`SellingOffice_MUI`: String ,`SerialNumber= `: > String ,`Site`: String ,`SoldTerms`: String ,`SourceofSquareFootage`: > String ,`SqFtFinishedTotal`: String ,`StateOrProvince`: String ,`Status`: > String ,`Style`: String ,`SupplementPublicCount`: String ,`Surveyed`: > String ,`TaxYear`: String ,`ThreeBedroomUnits`: String ,`Transportation`: > String ,`TwoBedroomUnits`: String ,`UnitType`: String ,`UnitsInBuilding`: > String ,`VehicleStorage`: String ,`View`: String ,`VirtualTour`: String > ,`WasteWaterDisposal`: String ,`Water`: String ,`WaterBodyName`: String > ,`WaterBodyType`: String ,`WaterFrontage`: String ,`WaterFrontageOwned`: > String ,`WaterFrontageShared`: String ,`WaterHeater`: String ,`YearBuilt`= : > String ,`Zoning`: String ,`matrix_unique_id`: String ,`removed_created_at= `: > String ,`sysid`: String> > basement` string > ) STORED AS parquet; > > > CREATE TABLE `property_feature`( > `_id` struct, > `all_attrs` > struct<1:string,10:string,100:string,105:string,113:string,118:string,126= :string,1299:string, > > 1301:string,1305:string,1307:string,1319:string,1325:string,1327:string,1= 329:string, > > 1339:string,1341:string,1345:string,1351:string,1353:string,1359:string,1= 363:string, > > 1365:string,1367:string,1373:string,1377:string,1397:string,1401:string,1= 403:string, > > 1405:string,1409:string,1411:string,1413:string,1417:string,1419:string,1= 421:string, > > 1423:string,1431:string,1437:string,1439:string,144:string,1441:string,14= 5:string,1451:string, > > 1453:string,146:string,1467:string,1469:string,1483:string,1485:string,14= 91:string,1493:string, > > 15:string,1505:string,1519:string,1521:string,1523:string,155:string,156:= string,158:string, > > 1586:string,1678:string,169:string,17:string,177:string,1783:string,1785:= string,1787:string, > > 1789:string,1793:string,1795:string,1797:string,1799:string,1801:string,1= 803:string,1805:string, > > 1807:string,1809:string,1811:string,1815:string,1818:string,1826:string,1= 829:string,1874:string, > > 1876:string,1878:string,1880:string,1882:string,207:string,215:string,226= :string,2293:string, > > 232:string,239:string,241:string,245:string,2456:string,248:string,2482:s= tring,2490:string, > > 2491:string,2492:string,2493:string,2495:string,25:string,2502:string,250= 3:string,2517:string, > > 2522:string,255:string,256:string,2573:string,2574:string,260:string,263:= string,265:string, > > 276:string,278:string,286:string,293:string,296:string,299:string,3:strin= g,30:string,307:string, > > 312:string,320:string,328:string,340:string,348:string,354:string,363:str= ing,364:string,369:string, > > 375:string,376:string,383:string,401:string,405:string,409:string,412:str= ing,42:string,423:string,444:string,445:string,446:string,447:string,450:st= ring,451:string,452:string,453:string,455:string,458:string,461:string,463:= string,464:string,51:string,543472980:string,57:string,75:string,90:string,= 92:string,AVMYN:string,AccessibilityAmenities:string, > > AddressPublic:string,Amenities:string,AmountofWaterFront:string,Appliance= sIncluded:string,AppraiserInitials:string,AppraiserName:string,Basement:str= ing,BathsFull:string,BathsHalf:string,BathsTotal:string,BedsTotal:string,Bl= ock:string,Book:string,BuildingNumber:string,City:string,CloseDate:string,C= losePrice:string,CoListAgentDirectWorkPhone:string,CoListAgentEmail:string,= CoListAgentFullName:string,CoListAgentMLSID:string,CoListAgent_MUI:string,C= oListOfficeMLSID:string,CoListOfficeName:string,CoListOfficePhone:string, > > CoListOffice_MUI:string,Color:string,CommentsYN:string,Construction:strin= g,Cooling:string,CountyOrParish:string,DOM:string,Deed:string,Directions:st= ring,Driveway:string,Electric:string,Equipment:string,Exterior:string,Firep= lace:string,FloorNumber:string,Floors:string,FoundationMaterials:string,Ful= lTaxAmount:string,Gas:string,HeatFuel:string,HeatSystem:string,Internet:str= ing,ListAgentDirectWorkPhone:string,ListAgentEmail:string,ListAgentFullName= :string,ListAgentMLSID:string,ListAgent_MUI:string,ListOfficeMLSID:string,L= istOfficeName:string,ListOfficePhone:string,ListOffice_MUI:string,ListPrice= :string,ListingContractDate:string,Location:string,Lot:string,LotSizeArea:s= tring,MLSNumber:string,Make:string,MapNumber:string,MatrixModifiedDT:string= ,MobileHomeIncludes:string,Model:string,MonthlyAssociationFee:string,Neighb= orhoodAssoc:string,NumberOfRooms:string,OneBedroomUnits:string,OriginalList= Price:string,Page:string,Parking:string,PhotoCount:string,PhotoModification= Timestamp:string,PostalCode:string,PropertySubType:string,PropertyType:stri= ng,PublicAddress:string,RecreationalWater:string,Remarks:string,Restriction= s:string,RoadFrontage:string,Roads:string,Roof:string,SchoolDistrict:string= ,Seasonal:string,SellingAgentDirectWorkPhone:string,SellingAgentEmail:strin= g,SellingAgentFullName:string,SellingAgentMLSID:string,SellingAgent_MUI:str= ing,SellingOfficeMLSID:string,SellingOfficeName:string,SellingOfficePhone:s= tring,SellingOffice_MUI:string,SerialNumber:string,Site:string,SoldTerms:st= ring, > SourceofSquareFootage:string,SqFtFinishedTotal:string,StateOrProvinc, > `basement` string > ) STORED AS parquet; > > Please help out in case if there is any workaround for it or any other > restriction details. > > Regards, > Satyajit. > > --089e0149d2bac5fed4052d2c319e Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I had a similar issue when using Hive and trying to create= a 400+ column table. Are you using HDP or have Apache Atlas anywhere in yo= ur ecosystem? If so, try disabling Apache Atlas and see if the issue goes a= way. My issue seemed be related to the fact that the Apache Atlas system wa= s erroring when a really long query was being issued.=C2=A0

On Thu, Mar 3, 2016 at 2:02= PM, satyajit vegesna <satyajit.apasprk@gmail.com> = wrote:

Hi All,

I am= trying to create a table with multiple STRUCT column types, one of which h= aving more than 300 fields.

I get the table created with no pr= oblem, but when i load i face few errors in loading up the data.when i chec= k SHOW CREATE TABLE TABLENAME, i get fields only till 266th column and rest= of them do not appear in the table DDL.

Would like to know, i= f there is any restriction on the number of fields to be using in STRUCT da= tatype.

EXAMPLE:

BELOW IS THE DDL i run in hive a= nd the below in red is the TABLE DDL i get from SHOW CREATE TABLE.
=
CREATE TABLE property_feature.property_feature_new(
`_id` STRUCT<= `mls_sysid`:String,`type`:String>,
all_attrs STRUCT<`1`: String ,`= 10`: String ,`100`: String ,`105`: String ,`113`: String ,`118`: String ,`1= 26`: String ,`1299`: String ,`1301`: String ,`1305`: String ,`1307`: String= ,`1319`: String ,`1325`: String ,`1327`: String ,`1329`: String ,`1339`: S= tring ,`1341`: String ,`1345`: String ,`1351`: String ,`1353`: String ,`135= 9`: String ,`1363`: String ,`1365`: String ,`1367`: String ,`1373`: String = ,`1377`: String ,`1397`: String ,`1401`: String ,`1403`: String ,`1405`: St= ring ,`1409`: String ,`1411`: String ,`1413`: String ,`1417`: String ,`1419= `: String ,`1421`: String ,`1423`: String ,`1431`: String ,`1437`: String ,= `1439`: String ,`144`: String ,`1441`: String ,`145`: String ,`1451`: Strin= g ,`1453`: String ,`146`: String ,`1467`: String ,`1469`: String ,`1483`: S= tring ,`1485`: String ,`1491`: String ,`1493`: String ,`15`: String ,`1505`= : String ,`1519`: String ,`1521`: String ,`1523`: String ,`155`: String ,`1= 56`: String ,`158`: String ,`1586`: String ,`1678`: String ,`169`: String ,= `17`: String ,`177`: String ,`1783`: String ,`1785`: String ,`1787`: String= ,`1789`: String ,`1793`: String ,`1795`: String ,`1797`: String ,`1799`: S= tring ,`1801`: String ,`1803`: String ,`1805`: String ,`1807`: String ,`180= 9`: String ,`1811`: String ,`1815`: String ,`1818`: String ,`1826`: String = ,`1829`: String ,`1874`: String ,`1876`: String ,`1878`: String ,`1880`: St= ring ,`1882`: String ,`207`: String ,`215`: String ,`226`: String ,`2293`: = String ,`232`: String ,`239`: String ,`241`: String ,`245`: String ,`2456`:= String ,`248`: String ,`2482`: String ,`2490`: String ,`2491`: String ,`24= 92`: String ,`2493`: String ,`2495`: String ,`25`: String ,`2502`: String ,= `2503`: String ,`2517`: String ,`2522`: String ,`255`: String ,`256`: Strin= g ,`2573`: String ,`2574`: String ,`260`: String ,`263`: String ,`265`: Str= ing ,`276`: String ,`278`: String ,`286`: String ,`293`: String ,`296`: Str= ing ,`299`: String ,`3`: String ,`30`: String ,`307`: String ,`312`: String= ,`320`: String ,`328`: String ,`340`: String ,`348`: String ,`354`: String= ,`363`: String ,`364`: String ,`369`: String ,`375`: String ,`376`: String= ,`383`: String ,`401`: String ,`405`: String ,`409`: String ,`412`: String= ,`42`: String ,`423`: String ,`444`: String ,`445`: String ,`446`: String = ,`447`: String ,`450`: String ,`451`: String ,`452`: String ,`453`: String = ,`455`: String ,`458`: String ,`461`: String ,`463`: String ,`464`: String = ,`51`: String ,`543472980`: String ,`57`: String ,`75`: String ,`90`: Strin= g ,`92`: String ,`AVMYN`: String ,`AccessibilityAmenities`: String ,`Addres= sPublic`: String ,`Amenities`: String ,`AmountofWaterFront`: String ,`Appli= ancesIncluded`: String ,`AppraiserInitials`: String ,`AppraiserName`: Strin= g ,`Basement`: String ,`BathsFull`: String ,`BathsHalf`: String ,`BathsTota= l`: String ,`BedsTotal`: String ,`Block`: String ,`Book`: String ,`Building= Number`: String ,`City`: String ,`CloseDate`: String ,`ClosePrice`: String = ,
`CoListAgentDirectWorkPhone`: String ,`CoListAgentEmail`: String ,`CoL= istAgentFullName`: String ,`CoListAgentMLSID`: String ,`CoListAgent_MUI`: S= tring ,`CoListOfficeMLSID`: String ,`CoListOfficeName`: String ,`CoListOffi= cePhone`: String ,`CoListOffice_MUI`: String ,`Color`: String ,`CommentsYN`= : String ,`Construction`: String ,`Cooling`: String ,`CountyOrParish`: Stri= ng ,`DOM`: String ,`Deed`: String ,`Directions`: String ,`Driveway`: String= ,`Electric`: String ,`Equipment`: String ,`Exterior`: String ,`Fireplace`:= String ,`FloorNumber`: String ,`Floors`: String ,`FoundationMaterials`: St= ring ,`FullTaxAmount`: String ,`Gas`: String ,`HeatFuel`: String ,`HeatSyst= em`: String ,`Internet`: String ,`ListAgentDirectWorkPhone`: String ,`ListA= gentEmail`: String ,`ListAgentFullName`: String ,`ListAgentMLSID`: String ,= `ListAgent_MUI`: String ,`ListOfficeMLSID`: String ,`ListOfficeName`: Strin= g ,`ListOfficePhone`: String ,`ListOffice_MUI`: String ,`ListPrice`: String= ,`ListingContractDate`: String ,`Location`: String ,`Lot`: String ,`LotSiz= eArea`: String ,`MLSNumber`: String ,`Make`: String ,`MapNumber`: String ,`= MatrixModifiedDT`: String ,`MobileHomeIncludes`: String ,`Model`: String ,`= MonthlyAssociationFee`: String ,`NeighborhoodAssoc`: String ,`NumberOfRooms= `: String ,`OneBedroomUnits`: String ,`OriginalListPrice`: String ,`Page`: = String ,`Parking`: String ,`PhotoCount`: String ,`PhotoModificationTimestam= p`: String ,`PostalCode`: String ,`PropertySubType`: String ,`PropertyType`= : String ,`PublicAddress`: String ,`RecreationalWater`: String ,`Remarks`: = String ,`Restrictions`: String ,`RoadFrontage`: String ,`Roads`: String ,`R= oof`: String ,`SchoolDistrict`: String ,`Seasonal`: String ,`SellingAgentDi= rectWorkPhone`: String ,`SellingAgentEmail`: String ,`SellingAgentFullName`= : String ,`SellingAgentMLSID`: String ,`SellingAgent_MUI`: String ,`Selling= OfficeMLSID`: String ,`SellingOfficeName`: String ,`SellingOfficePhone`: St= ring ,`SellingOffice_MUI`: String ,`SerialNumber`: String ,`Site`: String ,= `SoldTerms`: String ,`SourceofSquareFootage`: String ,`SqFtFinishedTotal`: = String ,`StateOrProvince`: String ,`Status`: String ,`Style`: String ,`Supp= lementPublicCount`: String ,`Surveyed`: String ,`TaxYear`: String ,`ThreeBe= droomUnits`: String ,`Transportation`: String ,`TwoBedroomUnits`: String ,`= UnitType`: String ,`UnitsInBuilding`: String ,`VehicleStorage`: String ,`Vi= ew`: String ,`VirtualTour`: String ,`WasteWaterDisposal`: String ,`Water`: = String ,`WaterBodyName`: String ,`WaterBodyType`: String ,`WaterFrontage`: = String ,`WaterFrontageOwned`: String ,`WaterFrontageShared`: String ,`Water= Heater`: String ,`YearBuilt`: String ,`Zoning`: String ,`matrix_unique_id`:= String ,`removed_created_at`: String ,`sysid`: String>
basement` str= ing
) STORED AS parquet;


CREATE TABLE `property_feature`(
=C2=A0 `_id` struct<mls_= sysid:string,type:string>,
=C2=A0 `all_attrs` struct<1:string,10:= string,100:string,105:string,113:string,118:string,126:string,1299:string,<= br>1301:string,1305:string,1307:string,1319:string,1325:string,1327:string,= 1329:string,
1339:string,1341:string,1345:string,1351:string,1353:string= ,1359:string,1363:string,
1365:string,1367:string,1373:string,1377:strin= g,1397:string,1401:string,1403:string,
1405:string,1409:string,1411:stri= ng,1413:string,1417:string,1419:string,1421:string,
1423:string,1431:str= ing,1437:string,1439:string,144:string,1441:string,145:string,1451:string,<= br>1453:string,146:string,1467:string,1469:string,1483:string,1485:string,1= 491:string,1493:string,
15:string,1505:string,1519:string,1521:string,15= 23:string,155:string,156:string,158:string,
1586:string,1678:string,169:= string,17:string,177:string,1783:string,1785:string,1787:string,
1789:st= ring,1793:string,1795:string,1797:string,1799:string,1801:string,1803:strin= g,1805:string,
1807:string,1809:string,1811:string,1815:string,1818:stri= ng,1826:string,1829:string,1874:string,
1876:string,1878:string,1880:str= ing,1882:string,207:string,215:string,226:string,2293:string,
232:string= ,239:string,241:string,245:string,2456:string,248:string,2482:string,2490:s= tring,
2491:string,2492:string,2493:string,2495:string,25:string,2502:st= ring,2503:string,2517:string,
2522:string,255:string,256:string,2573:str= ing,2574:string,260:string,263:string,265:string,
276:string,278:string,= 286:string,293:string,296:string,299:string,3:string,30:string,307:string,<= br>312:string,320:string,328:string,340:string,348:string,354:string,363:st= ring,364:string,369:string,
375:string,376:string,383:string,401:string,= 405:string,409:string,412:string,42:string,423:string,444:string,445:string= ,446:string,447:string,450:string,451:string,452:string,453:string,455:stri= ng,458:string,461:string,463:string,464:string,51:string,543472980:string,5= 7:string,75:string,90:string,92:string,AVMYN:string,AccessibilityAmenities:= string,
AddressPublic:string,Amenities:string,AmountofWaterFront:string,= AppliancesIncluded:string,AppraiserInitials:string,AppraiserName:string,Bas= ement:string,BathsFull:string,BathsHalf:string,BathsTotal:string,BedsTotal:= string,Block:string,Book:string,BuildingNumber:string,City:string,CloseDate= :string,ClosePrice:string,CoListAgentDirectWorkPhone:string,CoListAgentEmai= l:string,CoListAgentFullName:string,CoListAgentMLSID:string,CoListAgent_MUI= :string,CoListOfficeMLSID:string,CoListOfficeName:string,CoListOfficePhone:= string,
CoListOffice_MUI:string,Color:string,CommentsYN:string,Construct= ion:string,Cooling:string,CountyOrParish:string,DOM:string,Deed:string,Dire= ctions:string,Driveway:string,Electric:string,Equipment:string,Exterior:str= ing,Fireplace:string,FloorNumber:string,Floors:string,FoundationMaterials:s= tring,FullTaxAmount:string,Gas:string,HeatFuel:string,HeatSystem:string,Int= ernet:string,ListAgentDirectWorkPhone:string,ListAgentEmail:string,ListAgen= tFullName:string,ListAgentMLSID:string,ListAgent_MUI:string,ListOfficeMLSID= :string,ListOfficeName:string,ListOfficePhone:string,ListOffice_MUI:string,= ListPrice:string,ListingContractDate:string,Location:string,Lot:string,LotS= izeArea:string,MLSNumber:string,Make:string,MapNumber:string,MatrixModified= DT:string,MobileHomeIncludes:string,Model:string,MonthlyAssociationFee:stri= ng,NeighborhoodAssoc:string,NumberOfRooms:string,OneBedroomUnits:string,Ori= ginalListPrice:string,Page:string,Parking:string,PhotoCount:string,PhotoMod= ificationTimestamp:string,PostalCode:string,PropertySubType:string,Property= Type:string,PublicAddress:string,RecreationalWater:string,Remarks:string,Re= strictions:string,RoadFrontage:string,Roads:string,Roof:string,SchoolDistri= ct:string,Seasonal:string,SellingAgentDirectWorkPhone:string,SellingAgentEm= ail:string,SellingAgentFullName:string,SellingAgentMLSID:string,SellingAgen= t_MUI:string,SellingOfficeMLSID:string,SellingOfficeName:string,SellingOffi= cePhone:string,SellingOffice_MUI:string,SerialNumber:string,Site:string,Sol= dTerms:string,
SourceofSquareFootage:string,SqFtFinishedTotal:string= ,StateOrProvinc,
`basement` string
) STORED AS parquet= ;

Please help out in case if there is= any workaround for it or any other restriction details.

= Regards,
Satyajit.


--089e0149d2bac5fed4052d2c319e--