Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CALKvMUWOhzshVK8Tzoe_HksUiZyQqMx1JhZ_wnFHf4RXu33F7A@mail.gmail.com>
References: 
 <CALKvMUWOhzshVK8Tzoe_HksUiZyQqMx1JhZ_wnFHf4RXu33F7A@mail.gmail.com>
Date: Thu, 3 Mar 2016 12:02:38 -0800
Message-ID: 
 <CALKvMUXPOvNAf1ABxmeWW4ibd-LQLFZ8nk8SpC1c7SRe7FdD=A@mail.gmail.com>
Subject: Fwd: Hive Struct Type Restrictions.
From: satyajit vegesna <satyajit.apasprk@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=001a11407c7cfdc6a4052d2a7ad6

--001a11407c7cfdc6a4052d2a7ad6
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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 errors
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 to
be using in STRUCT datatype.

EXAMPLE:

BELOW IS THE DDL i run in hive and 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 ,`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`: String
,`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`: String
,`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<mls_sysid:string,type:string>,
  `all_attrs`
struct<1:string,10:string,100:string,105:string,113:string,118:string,126:s=
tring,1299:string,
1301:string,1305:string,1307:string,1319:string,1325:string,1327:string,132=
9:string,
1339:string,1341:string,1345:string,1351:string,1353:string,1359:string,136=
3:string,
1365:string,1367:string,1373:string,1377:string,1397:string,1401:string,140=
3:string,
1405:string,1409:string,1411:string,1413:string,1417:string,1419:string,142=
1: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:st=
ring,158:string,
1586:string,1678:string,169:string,17:string,177:string,1783:string,1785:st=
ring,1787:string,
1789:string,1793:string,1795:string,1797:string,1799:string,1801:string,180=
3:string,1805:string,
1807:string,1809:string,1811:string,1815:string,1818:string,1826:string,182=
9:string,1874:string,
1876:string,1878:string,1880:string,1882:string,207:string,215:string,226:s=
tring,2293:string,
232:string,239:string,241:string,245:string,2456:string,248:string,2482:str=
ing,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:st=
ring,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:strin=
g,364:string,369:string,
375:string,376:string,383:string,401:string,405:string,409:string,412:strin=
g,42:string,423:string,444:string,445:string,446:string,447:string,450:stri=
ng,451:string,452:string,453:string,455:string,458:string,461:string,463:st=
ring,464:string,51:string,543472980:string,57:string,75:string,90:string,92=
:string,AVMYN:string,AccessibilityAmenities:string,
AddressPublic:string,Amenities:string,AmountofWaterFront:string,AppliancesI=
ncluded:string,AppraiserInitials:string,AppraiserName:string,Basement:strin=
g,BathsFull:string,BathsHalf:string,BathsTotal:string,BedsTotal:string,Bloc=
k:string,Book:string,BuildingNumber:string,City:string,CloseDate:string,Clo=
sePrice:string,CoListAgentDirectWorkPhone:string,CoListAgentEmail:string,Co=
ListAgentFullName:string,CoListAgentMLSID:string,CoListAgent_MUI:string,CoL=
istOfficeMLSID:string,CoListOfficeName:string,CoListOfficePhone:string,
CoListOffice_MUI:string,Color:string,CommentsYN:string,Construction:string,=
Cooling:string,CountyOrParish:string,DOM:string,Deed:string,Directions:stri=
ng,Driveway:string,Electric:string,Equipment:string,Exterior:string,Firepla=
ce:string,FloorNumber:string,Floors:string,FoundationMaterials:string,FullT=
axAmount:string,Gas:string,HeatFuel:string,HeatSystem:string,Internet:strin=
g,ListAgentDirectWorkPhone:string,ListAgentEmail:string,ListAgentFullName:s=
tring,ListAgentMLSID:string,ListAgent_MUI:string,ListOfficeMLSID:string,Lis=
tOfficeName:string,ListOfficePhone:string,ListOffice_MUI:string,ListPrice:s=
tring,ListingContractDate:string,Location:string,Lot:string,LotSizeArea:str=
ing,MLSNumber:string,Make:string,MapNumber:string,MatrixModifiedDT:string,M=
obileHomeIncludes:string,Model:string,MonthlyAssociationFee:string,Neighbor=
hoodAssoc:string,NumberOfRooms:string,OneBedroomUnits:string,OriginalListPr=
ice:string,Page:string,Parking:string,PhotoCount:string,PhotoModificationTi=
mestamp:string,PostalCode:string,PropertySubType:string,PropertyType:string=
,PublicAddress:string,RecreationalWater:string,Remarks:string,Restrictions:=
string,RoadFrontage:string,Roads:string,Roof:string,SchoolDistrict:string,S=
easonal:string,SellingAgentDirectWorkPhone:string,SellingAgentEmail:string,=
SellingAgentFullName:string,SellingAgentMLSID:string,SellingAgent_MUI:strin=
g,SellingOfficeMLSID:string,SellingOfficeName:string,SellingOfficePhone:str=
ing,SellingOffice_MUI:string,SerialNumber:string,Site:string,SoldTerms:stri=
ng,
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.

--001a11407c7cfdc6a4052d2a7ad6
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><br><div class=3D"gmail_quote"><div dir=3D"ltr"><span styl=
e=3D"background-color:rgb(241,194,50)"><span></span></span>Hi All,<br><div>=
<div><div><div><div><br></div>I am trying to create a table with multiple S=
TRUCT column types, one of which having more than 300 fields.<br><br></div>=
I get the table created with no problem, but when i load i face few errors =
in loading up the data.when i check SHOW CREATE TABLE TABLENAME, i get fiel=
ds only till 266th column and rest of them do not appear in the table DDL.<=
br><br></div>Would like to know, if there is any restriction on the number =
of fields to be using in STRUCT datatype.<br><br></div>EXAMPLE:<br><br></di=
v>BELOW IS THE DDL i run in hive and the below in red is the TABLE DDL i ge=
t from SHOW CREATE TABLE.<br><div><br>CREATE TABLE property_feature.propert=
y_feature_new(<br>`_id` STRUCT&lt;`mls_sysid`:String,`type`:String&gt;,<br>=
all_attrs STRUCT&lt;`1`: String ,`10`: String ,`100`: String ,`105`: String=
 ,`113`: String ,`118`: String ,`126`: String ,`1299`: String ,`1301`: Stri=
ng ,`1305`: String ,`1307`: String ,`1319`: String ,`1325`: String ,`1327`:=
 String ,`1329`: String ,`1339`: String ,`1341`: String ,`1345`: String ,`1=
351`: String ,`1353`: String ,`1359`: String ,`1363`: String ,`1365`: Strin=
g ,`1367`: String ,`1373`: String ,`1377`: String ,`1397`: String ,`1401`: =
String ,`1403`: String ,`1405`: String ,`1409`: String ,`1411`: String ,`14=
13`: String ,`1417`: String ,`1419`: String ,`1421`: String ,`1423`: String=
 ,`1431`: String ,`1437`: String ,`1439`: String ,`144`: String ,`1441`: St=
ring ,`145`: String ,`1451`: String ,`1453`: String ,`146`: String ,`1467`:=
 String ,`1469`: String ,`1483`: String ,`1485`: String ,`1491`: String ,`1=
493`: String ,`15`: String ,`1505`: String ,`1519`: String ,`1521`: String =
,`1523`: String ,`155`: String ,`156`: String ,`158`: String ,`1586`: Strin=
g ,`1678`: String ,`169`: String ,`17`: String ,`177`: String ,`1783`: Stri=
ng ,`1785`: String ,`1787`: String ,`1789`: String ,`1793`: String ,`1795`:=
 String ,`1797`: String ,`1799`: String ,`1801`: String ,`1803`: String ,`1=
805`: String ,`1807`: String ,`1809`: String ,`1811`: String ,`1815`: Strin=
g ,`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 ,`24=
1`: String ,`245`: String ,`2456`: String ,`248`: String ,`2482`: String ,`=
2490`: String ,`2491`: String ,`2492`: String ,`2493`: String ,`2495`: Stri=
ng ,`25`: String ,`2502`: String ,`2503`: String ,`2517`: String ,`2522`: S=
tring ,`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`: St=
ring ,`307`: String ,`312`: String ,`320`: String ,`328`: String ,`340`: St=
ring ,`348`: String ,`354`: String ,`363`: String ,`364`: String ,`369`: St=
ring ,`375`: String ,`376`: String ,`383`: String ,`401`: String ,`405`: St=
ring ,`409`: String ,`412`: String ,`42`: String ,`423`: String ,`444`: Str=
ing ,`445`: String ,`446`: String ,`447`: String ,`450`: String ,`451`: Str=
ing ,`452`: String ,`453`: String ,`455`: String ,`458`: String ,`461`: Str=
ing ,`463`: String ,`464`: String ,`51`: String ,`543472980`: String ,`57`:=
 String ,`75`: String ,`90`: String ,`92`: String ,`AVMYN`: String ,`Access=
ibilityAmenities`: String ,`AddressPublic`: String ,`Amenities`: String ,`A=
mountofWaterFront`: String ,`AppliancesIncluded`: String ,`AppraiserInitial=
s`: String ,`AppraiserName`: String ,`Basement`: String ,`BathsFull`: Strin=
g ,`BathsHalf`: String ,`BathsTotal`: String ,`BedsTotal`: String ,`Block`:=
 String ,`Book`: String ,`BuildingNumber`: String ,`City`: String ,`CloseDa=
te`: String ,`ClosePrice`: String ,<br>`CoListAgentDirectWorkPhone`: String=
 ,`CoListAgentEmail`: String ,`CoListAgentFullName`: String ,`CoListAgentML=
SID`: String ,`CoListAgent_MUI`: String ,`CoListOfficeMLSID`: String ,`CoLi=
stOfficeName`: String ,`CoListOfficePhone`: String ,`CoListOffice_MUI`: Str=
ing ,`Color`: String ,`CommentsYN`: String ,`Construction`: String ,`Coolin=
g`: String ,`CountyOrParish`: String ,`DOM`: String ,`Deed`: String ,`Direc=
tions`: String ,`Driveway`: String ,`Electric`: String ,`Equipment`: String=
 ,`Exterior`: String ,`Fireplace`: String ,`FloorNumber`: String ,`Floors`:=
 String ,`FoundationMaterials`: String ,`FullTaxAmount`: String ,`Gas`: Str=
ing ,`HeatFuel`: String ,`HeatSystem`: String ,`Internet`: String ,`ListAge=
ntDirectWorkPhone`: String ,`ListAgentEmail`: String ,`ListAgentFullName`: =
String ,`ListAgentMLSID`: String ,`ListAgent_MUI`: String ,`ListOfficeMLSID=
`: String ,`ListOfficeName`: String ,`ListOfficePhone`: String ,`ListOffice=
_MUI`: String ,`ListPrice`: String ,`ListingContractDate`: String ,`Locatio=
n`: String ,`Lot`: String ,`LotSizeArea`: String ,`MLSNumber`: String ,`Mak=
e`: String ,`MapNumber`: String ,`MatrixModifiedDT`: String ,`MobileHomeInc=
ludes`: String ,`Model`: String ,`MonthlyAssociationFee`: String ,`Neighbor=
hoodAssoc`: String ,`NumberOfRooms`: String ,`OneBedroomUnits`: String ,`Or=
iginalListPrice`: String ,`Page`: String ,`Parking`: String ,`PhotoCount`: =
String ,`PhotoModificationTimestamp`: String ,`PostalCode`: String ,`Proper=
tySubType`: String ,`PropertyType`: String ,`PublicAddress`: String ,`Recre=
ationalWater`: String ,`Remarks`: String ,`Restrictions`: String ,`RoadFron=
tage`: String ,`Roads`: String ,`Roof`: String ,`SchoolDistrict`: String ,`=
Seasonal`: String ,`SellingAgentDirectWorkPhone`: String ,`SellingAgentEmai=
l`: String ,`SellingAgentFullName`: String ,`SellingAgentMLSID`: String ,`S=
ellingAgent_MUI`: String ,`SellingOfficeMLSID`: String ,`SellingOfficeName`=
: String ,`SellingOfficePhone`: String ,`SellingOffice_MUI`: String ,`Seria=
lNumber`: String ,`Site`: String ,`SoldTerms`: String ,`SourceofSquareFoota=
ge`: String ,`SqFtFinishedTotal`: String ,`StateOrProvince`: String ,`Statu=
s`: String ,`Style`: String ,`SupplementPublicCount`: String ,`Surveyed`: S=
tring ,`TaxYear`: String ,`ThreeBedroomUnits`: String ,`Transportation`: St=
ring ,`TwoBedroomUnits`: String ,`UnitType`: String ,`UnitsInBuilding`: Str=
ing ,`VehicleStorage`: String ,`View`: String ,`VirtualTour`: String ,`Wast=
eWaterDisposal`: String ,`Water`: String ,`WaterBodyName`: String ,`WaterBo=
dyType`: String ,`WaterFrontage`: String ,`WaterFrontageOwned`: String ,`Wa=
terFrontageShared`: String ,`WaterHeater`: String ,`YearBuilt`: String ,`Zo=
ning`: String ,`matrix_unique_id`: String ,`removed_created_at`: String ,`s=
ysid`: String&gt;<br>basement` string<br>) STORED AS parquet;<br><br><br><s=
pan style=3D"background-color:rgb(255,255,0)">CREATE TABLE `property_featur=
e`(<br>=C2=A0 `_id` struct&lt;mls_sysid:string,type:string&gt;, <br>=C2=A0 =
`all_attrs` struct&lt;1:string,10:string,100:string,105:string,113:string,1=
18:string,126:string,1299:string,<br>1301:string,1305:string,1307:string,13=
19:string,1325:string,1327:string,1329:string,<br>1339:string,1341:string,1=
345:string,1351:string,1353:string,1359:string,1363:string,<br>1365:string,=
1367:string,1373:string,1377:string,1397:string,1401:string,1403:string,<br=
>1405:string,1409:string,1411:string,1413:string,1417:string,1419:string,14=
21:string,<br>1423:string,1431:string,1437:string,1439:string,144:string,14=
41:string,145:string,1451:string,<br>1453:string,146:string,1467:string,146=
9:string,1483:string,1485:string,1491:string,1493:string,<br>15:string,1505=
:string,1519:string,1521:string,1523:string,155:string,156:string,158:strin=
g,<br>1586:string,1678:string,169:string,17:string,177:string,1783:string,1=
785:string,1787:string,<br>1789:string,1793:string,1795:string,1797:string,=
1799:string,1801:string,1803:string,1805:string,<br>1807:string,1809:string=
,1811:string,1815:string,1818:string,1826:string,1829:string,1874:string,<b=
r>1876:string,1878:string,1880:string,1882:string,207:string,215:string,226=
:string,2293:string,<br>232:string,239:string,241:string,245:string,2456:st=
ring,248:string,2482:string,2490:string,<br>2491:string,2492:string,2493:st=
ring,2495:string,25:string,2502:string,2503:string,2517:string,<br>2522:str=
ing,255:string,256:string,2573:string,2574:string,260:string,263:string,265=
:string,<br>276:string,278:string,286:string,293:string,296:string,299:stri=
ng,3:string,30:string,307:string,<br>312:string,320:string,328:string,340:s=
tring,348:string,354:string,363:string,364:string,369:string,<br>375:string=
,376:string,383:string,401:string,405:string,409:string,412:string,42:strin=
g,423:string,444:string,445:string,446:string,447:string,450:string,451:str=
ing,452:string,453:string,455:string,458:string,461:string,463:string,464:s=
tring,51:string,543472980:string,57:string,75:string,90:string,92:string,AV=
MYN:string,AccessibilityAmenities:string,<br>AddressPublic:string,Amenities=
:string,AmountofWaterFront:string,AppliancesIncluded:string,AppraiserInitia=
ls:string,AppraiserName:string,Basement:string,BathsFull:string,BathsHalf:s=
tring,BathsTotal:string,BedsTotal:string,Block:string,Book:string,BuildingN=
umber:string,City:string,CloseDate:string,ClosePrice:string,CoListAgentDire=
ctWorkPhone:string,CoListAgentEmail:string,CoListAgentFullName:string,CoLis=
tAgentMLSID:string,CoListAgent_MUI:string,CoListOfficeMLSID:string,CoListOf=
ficeName:string,CoListOfficePhone:string,<br>CoListOffice_MUI:string,Color:=
string,CommentsYN:string,Construction:string,Cooling:string,CountyOrParish:=
string,DOM:string,Deed:string,Directions:string,Driveway:string,Electric:st=
ring,Equipment:string,Exterior:string,Fireplace:string,FloorNumber:string,F=
loors:string,FoundationMaterials:string,FullTaxAmount:string,Gas:string,Hea=
tFuel:string,HeatSystem:string,Internet:string,ListAgentDirectWorkPhone:str=
ing,ListAgentEmail:string,ListAgentFullName:string,ListAgentMLSID:string,Li=
stAgent_MUI:string,ListOfficeMLSID:string,ListOfficeName:string,ListOfficeP=
hone:string,ListOffice_MUI:string,ListPrice:string,ListingContractDate:stri=
ng,Location:string,Lot:string,LotSizeArea:string,MLSNumber:string,Make:stri=
ng,MapNumber:string,MatrixModifiedDT:string,MobileHomeIncludes:string,Model=
:string,MonthlyAssociationFee:string,NeighborhoodAssoc:string,NumberOfRooms=
:string,OneBedroomUnits:string,OriginalListPrice:string,Page:string,Parking=
:string,PhotoCount:string,PhotoModificationTimestamp:string,PostalCode:stri=
ng,PropertySubType:string,PropertyType:string,PublicAddress:string,Recreati=
onalWater:string,Remarks:string,Restrictions:string,RoadFrontage:string,Roa=
ds:string,Roof:string,SchoolDistrict:string,Seasonal:string,SellingAgentDir=
ectWorkPhone:string,SellingAgentEmail:string,SellingAgentFullName:string,Se=
llingAgentMLSID:string,SellingAgent_MUI:string,SellingOfficeMLSID:string,Se=
llingOfficeName:string,SellingOfficePhone:string,SellingOffice_MUI:string,S=
erialNumber:string,Site:string,SoldTerms:string,<br>SourceofSquareFootage:<=
span style=3D"background-color:rgb(0,0,0)"><span style=3D"color:rgb(255,0,0=
)">string,SqFtFinishedTotal:string,StateOrProvinc,</span></span><br>`baseme=
nt` string <br>) STORED AS parquet;<span></span></span><br><br></div><div>P=
lease help out in case if there is any workaround for it or any other restr=
iction details.<br><br></div><div>Regards,<br></div><div>Satyajit.<br></div=
></div>
</div><br></div>

--001a11407c7cfdc6a4052d2a7ad6--