Jesus Camacho Rodriguez created HIVE-23224:
----------------------------------------------
Summary: 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
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)
