I'm trying to modify a script to allow for more code reuse, by prepending table names with a variable.
For example: CREATE TABLE etl_${hiveconf:table}_traffic AS ... The problem I'm running into is that after building all of these etl_* tables, I use a final query to join all of the tables and select all of the appropriate columns. In this query, I reference the ${hiveconf:table} variable 122 times, and end up receiving this error: "java.lang.IllegalStateException: Variable substitution depth too large: 40". According to a quick Google search, it appears that the limit of 40 is hardcoded into the VariableSubstitution class. Is there any way to override this in a hiveconf variable? Thanks Matt Tucker