You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2021/06/24 12:36:55 UTC

[GitHub] [superset] Ognian opened a new issue #15364: return cell fields instead of ordinal numbers on cell content or provide row signature in table schema

Ognian opened a new issue #15364:
URL: https://github.com/apache/superset/issues/15364


   <img width="781" alt="image" src="https://user-images.githubusercontent.com/1231174/123262343-112be780-d4f8-11eb-8be2-a9b6aeb7a582.png">
   
   when clicking on a cell of the type
   <img width="494" alt="image" src="https://user-images.githubusercontent.com/1231174/123262675-71228e00-d4f8-11eb-9586-434053b7d137.png">
   
   instead of returning just the ordinal numbers (which is synticatically also correct) the field id's should be returned ( in this case `street`,` zip`, `city`, `country` )
   
   At the moment this information is not displayed anywhere, but it is essential for writing queries.
   
   <img width="398" alt="image" src="https://user-images.githubusercontent.com/1231174/123263444-41c05100-d4f9-11eb-90ae-a0fcf3c971c1.png">
   
   An alternative way would be to add this info on the left side, where now only row is displayed and no more additional info
   
   This is essential when querying document based databases like mongodb via trino.
   
   Thanks
   Ognian


-- 
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


[GitHub] [superset] Ognian edited a comment on issue #15364: BUG: return cell fields instead of ordinal numbers on cell content or provide row signature in table schema

Posted by GitBox <gi...@apache.org>.
Ognian edited a comment on issue #15364:
URL: https://github.com/apache/superset/issues/15364#issuecomment-867646634


   Funny:
   <img width="604" alt="image" src="https://user-images.githubusercontent.com/1231174/123272357-f6f70700-d501-11eb-8c2a-a762fe1615d6.png">
   
   if I set the type of address to `varchar` I get the above display which is correct
   
   Could someone please explain to me why when setting the json to varchar it works and why if I enter the correct row(...) signature it doesn't?


-- 
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


[GitHub] [superset] Ognian commented on issue #15364: BUG: return cell fields instead of ordinal numbers on cell content or provide row signature in table schema

Posted by GitBox <gi...@apache.org>.
Ognian commented on issue #15364:
URL: https://github.com/apache/superset/issues/15364#issuecomment-867664215


   OK this is actually a BUG:
   if I get the correct content output by setting the type to `varchar` it is not possible to select i.e address.zip BUT if I set the correct type to `row("street" varchar,"zip" varchar,"city" varchar,"country" varchar)` I can select address.zip but get the array  display and have actually no way to figure out that there is an address.zip field


-- 
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


[GitHub] [superset] Ognian commented on issue #15364: return cell fields instead of ordinal numbers on cell content or provide row signature in table schema

Posted by GitBox <gi...@apache.org>.
Ognian commented on issue #15364:
URL: https://github.com/apache/superset/issues/15364#issuecomment-867646634


   Funny:
   <img width="604" alt="image" src="https://user-images.githubusercontent.com/1231174/123272357-f6f70700-d501-11eb-8c2a-a762fe1615d6.png">
   
   if I set the type of address to `varchar` I get the above display which is correct
   
   Could someone please explain to me why when setting the json to archer it works and why if I enter the correct row(...) signature it doesn't?


-- 
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org