Can I use pattern matching in Hive

Question

Hi. Is it possible to use pattern matching in Hive. I am using the SHOW TABLES command to list the tables present in the selected database. I was just wondering if I can use pattern matching to filter the results of this command.

Answer 1

Yes, it is possible to use pattern matching in Hive. Hive supports Java regular expressions. For example, if you want to print the name of the tables that end with the letter 's', then you will have to use a command as shown below:

hive> SHOW TABLES '*.s';