NageshB82 commented on issue #2302:
URL: https://github.com/apache/iceberg/issues/2302#issuecomment-805619263


   @RussellSpitzer As you suggested, We tried creating External table in spark 
(not iceberg table) as below and tried query on that
   
   `CREATE EXTERNAL TABLE Account(name  string,dn  string, accountCreationDate  
string, disabled  long, forceChangePwd long, pwdLife long, numberLoginError 
long, lastChangePwd  string,  lastLogin  string, lastWrongLogin  string, state 
long, expire  string,  lastCertTime  string, creationDate  string, creationUser 
string, challengeCounter long,challengeFailedAttempt long, targetName string, 
isDeleted  string, lastUpdatedTime  long,  id  string, sourceTypes  string, _id 
 string, type string, isimId string, externalId string)
       STORED AS PARQUET LOCATION '/root/Documents/Account';`
   
   Querying data in same way like we queried for iceberg table using thrift 
server, 
   Here I see each paginated records are fetching around 3-5 seconds for 20k 
records per page (while as Iceberg tables queries are taking 8-11 sec per page)
    
   
![image](https://user-images.githubusercontent.com/80257736/112281433-0f117d00-8cac-11eb-8c8b-00bdf8676516.png)
   
   
![image](https://user-images.githubusercontent.com/80257736/112281520-2486a700-8cac-11eb-8e68-9270ad30e107.png)
   
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to