Re: What is the default escape char

2018-10-27 Thread ZongtianHou
To be simple, what the escape character is when I run the below sql to create a table. Create table aa (a string, b string) stored as textfile; Need help!! > On 27 Oct 2018, at 9:27 PM, ZongtianHou wrote: > > If I set the escape char to ‘\’, then after I insert (‘\\’,’abc’) into a > table (a st

What is the default escape char

2018-10-27 Thread ZongtianHou
If I set the escape char to ‘\’, then after I insert (‘\\’,’abc’) into a table (a string, b string), on hdfs file the content is "\\",”abc" But if I don’t set it, the content will become \abc, which will caused the \ be looked as escape and the two columns table became one column, I wonder what

Can not do insert query error code -101

2018-10-27 Thread ZongtianHou
Hi, everyone, I have installed hive3.0 and tried it. I created a table , but can’t insert a record into it. Below is the operation and error info, any hint will be very appreciated! hive> create table ii(a int); OK Time taken: 1.337 seconds hive> insert into ii values (2); Query ID = kousouda_20