Re: Implement "DROP TABLE IIF EXISTS" statement

sounds good. We need to clear document this - specifically the Hive UDF IF syntax issue. -Neeraja On Fri, Jul 1, 2016 at 11:07 AM, Vitalii Diravka wrote: > Agree with the last decision to use "IF EXISTS" statement and `if` udf with > backticks. > It is acceptable

Re: Implement "DROP TABLE IIF EXISTS" statement

I agree with Julian. If we can backtick quote Hive's if and have an option for Hive users, it would be nice. But Hive made a mess, and there is precedent for IF. This makes from a cluster administration perspective, and even being a Hive user, as long as I had an option (with backticks) to allow

Re: Implement "DROP TABLE IIF EXISTS" statement

Even though it’s not standard, several other databases have DROP TABLE … IF EXISTS (MySQL [1]; Postgres [2] and SQL Server 2016 [3] put the “IF EXISTS” before the table name). I know there are problems with the IF keyword clashing with the Hive “IF” function, but I think it would be crazy to do

Re: Implement "DROP TABLE IIF EXISTS" statement

I looked at the SQL standard and I did not find that IF EXISTS is a part of DROP TABLE syntax, please see below. INTERNATIONAL STANDARD ISO/IEC 9075-2 Fourth edition 2011-12-15 Format ::= DROP TABLE ::= CASCADE | RESTRICT On Thu, Jun 30, 2016 at 3:44 PM, Arina Yelchiyeva <

Implement "DROP TABLE IIF EXISTS" statement

Hi all! I'm going to implement "DROP TABLE IIF EXISTS" and "DROP VIEW IIF EXISTS" statements in Drill (DRILL-4673 ). The reason of using "IIF" is inability of adding "IF" keyword to non-reserved words list (due to SQL:2011 standard which calcite