[
https://issues.apache.org/jira/browse/HIVE-23224?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jesus Camacho Rodriguez updated HIVE-23224:
-------------------------------------------
Target Version/s: 4.0.0
> Literals in CBO plan could show less information
> ------------------------------------------------
>
> Key: HIVE-23224
> URL: https://issues.apache.org/jira/browse/HIVE-23224
> Project: Hive
> Issue Type: Improvement
> Components: CBO
> Reporter: Jesus Camacho Rodriguez
> Assignee: Jesus Camacho Rodriguez
> Priority: Major
>
> Currently, they are very verbose. For all char and varchar literals it will
> show the encoding, thought it is always the same. For varchar literals, it
> prints type and length, which seems unnecessary.
> For instance:
> {code}
> HiveFilter(condition=[AND(IN($10,
> _UTF-16LE'wallpaper':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'parenting':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'musical':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'womens':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'birdal':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'pants':VARCHAR(2147483647) CHARACTER SET "UTF-16LE"), IN($12,
> _UTF-16LE'Home':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'Books':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'Electronics':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'Shoes':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'Jewelry':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'Men':VARCHAR(2147483647) CHARACTER SET "UTF-16LE"), OR(AND(IN($12,
> _UTF-16LE'Home':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'Books':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'Electronics':VARCHAR(2147483647) CHARACTER SET "UTF-16LE"), IN($10,
> _UTF-16LE'wallpaper':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'parenting':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'musical':VARCHAR(2147483647) CHARACTER SET "UTF-16LE")),
> AND(IN($12, _UTF-16LE'Shoes':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'Jewelry':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'Men':VARCHAR(2147483647) CHARACTER SET "UTF-16LE"), IN($10,
> _UTF-16LE'womens':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'birdal':VARCHAR(2147483647) CHARACTER SET "UTF-16LE",
> _UTF-16LE'pants':VARCHAR(2147483647) CHARACTER SET "UTF-16LE"))))])
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
