http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/a14a3ee1/core/sql/regress/executor/EXPECTED130
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED130 b/core/sql/regress/executor/EXPECTED130
index 0542d39..87a1d05 100644
--- a/core/sql/regress/executor/EXPECTED130
+++ b/core/sql/regress/executor/EXPECTED130
@@ -63,9 +63,9 @@ C1
C1 C2
----------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------
- 1 LOBH000000020001001830865086431665681818308650874102010718212359906316509152020"TRAFODION"."LOB130"
- 2 LOBH000000020001001830865086431665681818308650874653085818212359906323581515020"TRAFODION"."LOB130"
- 3 LOBH000000020001001830865086431665681818308650875141948918212359906328520376020"TRAFODION"."LOB130"
+ 1 LOBH000000020001004521773054977751551845217730572979065218212360625565346135020"TRAFODION"."LOB130"
+ 2 LOBH000000020001004521773054977751551845217730575426024718212360625592037380020"TRAFODION"."LOB130"
+ 3 LOBH000000020001004521773054977751551845217730577394592318212360625613791173020"TRAFODION"."LOB130"
--- 3 row(s) selected.
>>
@@ -209,21 +209,21 @@ var char 33333333333333333333333333333333333333333333333333333
>>insert into t130lob2 select [first 10] d_date_sk,d_date_id from hive.hive.date_dim;
--- 10 row(s) inserted.
->>select lobtostring(c2,40) from t130lob2 order by c1;
+>>select lobtostring(c2,4) from t130lob2 order by c1;
-(EXPR)
-----------------------------------------
+(EXPR)
+------
-AAAAAAAAOKJNECAA
-AAAAAAAAPKJNECAA
-AAAAAAAAALJNECAA
-AAAAAAAABLJNECAA
-AAAAAAAACLJNECAA
-AAAAAAAADLJNECAA
-AAAAAAAAELJNECAA
-AAAAAAAAFLJNECAA
-AAAAAAAAGLJNECAA
-AAAAAAAAHLJNECAA
+AAAA
+AAAA
+AAAA
+AAAA
+AAAA
+AAAA
+AAAA
+AAAA
+AAAA
+AAAA
--- 10 row(s) selected.
>>delete from t130lob2;
@@ -654,7 +654,7 @@ And the dish ran away with the fork !
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'tlob130_txt1.txt');/g" >> t130_extract_command;
>>
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH000000020001001830865086432349061818308650940724338718212359906984262764020"TRAFODION"."LOB130"
' , 'tlob130_txt1.txt');
+>>extract lobtofile(LOB 'LOBH000000020001004521773054979487561845217730741742859818212360627257261284020"TRAFODION"."LOB130"
' , 'tlob130_txt1.txt');
Success. Targetfile :tlob130_txt1.txt Length : 19
--- SQL operation complete.
@@ -670,7 +670,7 @@ Success. Targetfile :tlob130_txt1.txt Length : 19
>>sh rm t130_extract_command;
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'tlob130_deep.jpg');/g" >> t130_extract_command;
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH000000020001001830865086432359101818308650946460854518212359907041579214020"TRAFODION"."LOB130"
' , 'tlob130_deep.jpg');
+>>extract lobtofile(LOB 'LOBH000000020001004521773054979514421845217730753331456518212360627372759041020"TRAFODION"."LOB130"
' , 'tlob130_deep.jpg');
Success. Targetfile :tlob130_deep.jpg Length : 159018
--- SQL operation complete.
@@ -686,7 +686,7 @@ Success. Targetfile :tlob130_deep.jpg Length : 159018
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'tlob130_anoush.jpg');/g" >> t130_extract_command;
>>
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH000000020001001830865086432359101818308650946460854518212359907041579214020"TRAFODION"."LOB130"
' , 'tlob130_anoush.jpg');
+>>extract lobtofile(LOB 'LOBH000000020001004521773054979514421845217730753331456518212360627372759041020"TRAFODION"."LOB130"
' , 'tlob130_anoush.jpg');
Success. Targetfile :tlob130_anoush.jpg Length : 230150
--- SQL operation complete.
@@ -706,29 +706,29 @@ Success. Targetfile :tlob130_anoush.jpg Length : 230150
--- SQL operation complete.
>>
->>sh regrhadoop.ksh fs -copyFromLocal lob_input_a1.txt /lobs/lob_input_a1.txt;
->>sh regrhadoop.ksh fs -copyFromLocal lob_input_b1.txt /lobs/lob_input_b1.txt;
->>sh regrhadoop.ksh fs -copyFromLocal lob_input_c1.txt /lobs/lob_input_c1.txt;
->>sh regrhadoop.ksh fs -copyFromLocal lob_input_d1.txt /lobs/lob_input_d1.txt;
->>sh regrhadoop.ksh fs -copyFromLocal lob_input_e1.txt /lobs/lob_input_e1.txt;
->>sh regrhadoop.ksh fs -copyFromLocal deep.jpg /lobs/deep.jpg;
->>sh regrhadoop.ksh fs -copyFromLocal anoush.jpg /lobs/anoush.jpg;
+>>sh regrhadoop.ksh fs -copyFromLocal lob_input_a1.txt /user/trafodion/lobs/lob_input_a1.txt;
+>>sh regrhadoop.ksh fs -copyFromLocal lob_input_b1.txt /user/trafodion/lobs/lob_input_b1.txt;
+>>sh regrhadoop.ksh fs -copyFromLocal lob_input_c1.txt /user/trafodion/lobs/lob_input_c1.txt;
+>>sh regrhadoop.ksh fs -copyFromLocal lob_input_d1.txt /user/trafodion/lobs/lob_input_d1.txt;
+>>sh regrhadoop.ksh fs -copyFromLocal lob_input_e1.txt /user/trafodion/lobs/lob_input_e1.txt;
+>>sh regrhadoop.ksh fs -copyFromLocal deep.jpg /user/trafodion/lobs/deep.jpg;
+>>sh regrhadoop.ksh fs -copyFromLocal anoush.jpg /user/trafodion/lobs/anoush.jpg;
>>-- the next one is a really long file name intended to test error message 8557
->>sh regrhadoop.ksh fs -copyFromLocal lob_input_a1.txt /lobs/reallyLongDirectoryName0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789/lob_input_a1012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789.txt;
+>>sh regrhadoop.ksh fs -copyFromLocal lob_input_a1.txt /user/trafodion/lobs/reallyLongDirectoryName0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789/lob_input_a1012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789.txt;
>>sh sleep(20);
>>
>>
->>insert into tlob130txt2 values (1, filetolob('hdfs:///lobs/lob_input_a1.txt'));
+>>insert into tlob130txt2 values (1, filetolob('hdfs:///user/trafodion/lobs/lob_input_a1.txt'));
--- 1 row(s) inserted.
>>
>>-- second line
->>insert into tlob130txt2 values (2, filetolob('hdfs:///lobs/lob_input_b1.txt'));
+>>insert into tlob130txt2 values (2, filetolob('hdfs:///user/trafodion/lobs/lob_input_b1.txt'));
--- 1 row(s) inserted.
>>
>>-- third line
->>insert into tlob130txt2 values (3, filetolob('hdfs:///lobs/lob_input_c1.txt'));
+>>insert into tlob130txt2 values (3, filetolob('hdfs:///user/trafodion/lobs/lob_input_c1.txt'));
--- 1 row(s) inserted.
>>select lobtostring(c2, 40 ) from tlob130txt2;
@@ -748,7 +748,7 @@ The cow jumped over the moon.
>>--updates
>>
>>--should update with full poem
->>update tlob130txt2 set c2=filetolob('hdfs:///lobs/lob_input_d1.txt', append) where c1 = 3;
+>>update tlob130txt2 set c2=filetolob('hdfs:///user/trafodion/lobs/lob_input_d1.txt', append) where c1 = 3;
--- 1 row(s) updated.
>>select lobtostring(c2, 200 ) from tlob130txt2;
@@ -770,7 +770,7 @@ And the dish ran away with the spoon.
--- 3 row(s) selected.
>>
>>-- should see wrong text in the last few lines
->>update tlob130txt2 set c2=filetolob('hdfs:///lobs/lob_input_e1.txt') where c1 =3 ;
+>>update tlob130txt2 set c2=filetolob('hdfs:///user/trafodion/lobs/lob_input_e1.txt') where c1 =3 ;
--- 1 row(s) updated.
>>select lobtostring(c2, 200 ) from tlob130txt2;
@@ -805,13 +805,9 @@ And the dish ran away with the fork !
>>log;
>>sh rm t130_extract_command;
>>
->>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'hdfs:\/\/\/lobs\/tlob130_txt2.txt');/g" >> t130_extract_command;
+>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'hdfs:\/\/\/user/trafodion/lobs\/tlob130_txt2.txt');/g" >> t130_extract_command;
>>
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH000000020001001830865086432481141818308650954225440318212359907119296896020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_txt2.txt');
-Success. Targetfile :hdfs:///lobs/tlob130_txt2.txt Length : 19
-
---- SQL operation complete.
>>
>>--binary input/update
>>
@@ -822,12 +818,8 @@ Success. Targetfile :hdfs:///lobs/tlob130_txt2.txt Length : 19
>>
>>log;
>>sh rm t130_extract_command;
->>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'hdfs:\/\/\/lobs\/tlob130_deep.jpg');/g" >> t130_extract_command;
+>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'hdfs:\/\/\/user/trafodion/lobs\/tlob130_deep.jpg');/g" >> t130_extract_command;
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH000000020001001830865086432492771818308650960155056018212359907178472834020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_deep.jpg');
-Success. Targetfile :hdfs:///lobs/tlob130_deep.jpg Length : 159018
-
---- SQL operation complete.
>>
>>update tlob130bin2 set c2=filetolob('anoush.jpg') ;
@@ -837,13 +829,9 @@ Success. Targetfile :hdfs:///lobs/tlob130_deep.jpg Length : 159018
>>
>>log;
>>sh rm t130_extract_command;
->>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'hdfs:\/\/\/lobs\/tlob130_anoush.jpg');/g" >> t130_extract_command;
+>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'hdfs:\/\/\/user/trafodion/lobs\/tlob130_anoush.jpg');/g" >> t130_extract_command;
>>
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH000000020001001830865086432359101818308650946460854518212359907041579214020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush.jpg');
-Success. Targetfile :hdfs:///lobs/tlob130_anoush.jpg Length : 230150
-
---- SQL operation complete.
>>
>>
>>sh clitestdriver 2 < TEST130_argfile 2>&1 | tee -a LOG130;
@@ -859,7 +847,7 @@ Column Name : c2
Input a filename to extract to :
Output File Name : lobc2out.jpg
Extracting lob handle for column c2...
-LOB handle for c2: LOBH000000020001001830865086432359101818308650946460854518212359907041579214020"TRAFODION"."LOB130"
+LOB handle for c2: LOBH000000020001004521773054979514421845217730753331456518212360627372759041020"TRAFODION"."LOB130"
Extracting LOB data length for the above handle...
LOB data length :230150
Extracting lob data into file in chunks ...
@@ -933,19 +921,15 @@ And the dish ran away with the spoon.
>>sh rm t130_extract_command;
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'tlob130_deep2.jpg');/g" >> t130_extract_command;
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH000000020002001830865086432700361818308650973720712718212359907314128843020"TRAFODION"."LOB130"
' , 'tlob130_deep2.jpg');
+>>extract lobtofile(LOB 'LOBH000000020002004521773054980105951845217730796607893818212360627806139125020"TRAFODION"."LOB130"
' , 'tlob130_deep2.jpg');
Success. Targetfile :tlob130_deep2.jpg Length : 159018
--- SQL operation complete.
>>
>>log;
>>sh rm t130_extract_command;
->>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'hdfs:\/\/\/lobs\/tlob130_anoush2.jpg');/g" >> t130_extract_command;
+>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'hdfs:\/\/\/user/trafodion/lobs\/tlob130_anoush2.jpg');/g" >> t130_extract_command;
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH000000020003001830865086432700361818308650974204477218212359907318971086020"TRAFODION"."LOB130"
' , 'hdfs:///lobs/tlob130_anoush2.jpg');
-Success. Targetfile :hdfs:///lobs/tlob130_anoush2.jpg Length : 230150
-
---- SQL operation complete.
>>
>>-- combination blob and clob columns
>>create table tlob130bt (c1 int not null, c2 int, c3 blob, c4 clob, primary key (c1));
@@ -969,7 +953,7 @@ Hey diddle diddle,
>>sh rm t130_extract_command;
>>sh grep "^LOBH" TMP130 | sed "s/^/extract lobtofile(LOB '/g" | sed "s/$/' , 'tlob130_anoush3.jpg',create,truncate);/g" >> t130_extract_command;
>>obey t130_extract_command;
->>extract lobtofile(LOB 'LOBH000000020003001830865086432746671818308650978649997618212359907363638742020"TRAFODION"."LOB130"
' , 'tlob130_anoush3.jpg',create,truncate);
+>>extract lobtofile(LOB 'LOBH000000020003004521773054980180651845217730805462671518212360627894957464020"TRAFODION"."LOB130"
' , 'tlob130_anoush3.jpg',create,truncate);
Success. Targetfile :tlob130_anoush3.jpg Length : 230150
--- SQL operation complete.
@@ -1069,13 +1053,13 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT2
=========================
ColumnName : C2
- Lob Location : /lobs
- LOB Data File: LOBP_00183086508643303323_0001
+ Lob Location : /user/trafodion/lobs
+ LOB Data File: LOBP_00452177305498076106_0001
LOB EOD : 0
LOB Used Len : 0
ColumnName : C3
- Lob Location : /lobs
- LOB Data File: LOBP_00183086508643303323_0002
+ Lob Location : /user/trafodion/lobs
+ LOB Data File: LOBP_00452177305498076106_0002
LOB EOD : 0
LOB Used Len : 0
ColumnName : C4
@@ -1090,8 +1074,8 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT2
CATALOG_NAME SCHEMA_NAME OBJECT_NAME COLUMN_NAME
LOB_LOCATION LOB_DATA_FILE LOB_DATA_FILE_SIZE_EOD LOB_DATA_FILE_SIZE_USED
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------- -----------------------
-TRAFODION LOB130 TLOB130GT2 C2
/lobs LOBP_00183086508643303323_0001 0 0
-TRAFODION LOB130 TLOB130GT2 C3
/lobs LOBP_00183086508643303323_0002 0 0
+TRAFODION LOB130 TLOB130GT2 C2
/user/trafodion/lobs LOBP_00452177305498076106_0001 0 0
+TRAFODION LOB130 TLOB130GT2 C3
/user/trafodion/lobs LOBP_00452177305498076106_0002 0 0
TRAFODION LOB130 TLOB130GT2 C4
External HDFS Location External HDFS File 0 0
--- 3 row(s) selected.
@@ -1111,18 +1095,18 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
=========================
ColumnName : C2
- Lob Location : /lobs
- LOB Data File: LOBP_00183086508643300979_0001
+ Lob Location : /user/trafodion/lobs
+ LOB Data File: LOBP_00452177305498070471_0001
LOB EOD : 15
LOB Used Len : 15
ColumnName : C3
- Lob Location : /lobs
- LOB Data File: LOBP_00183086508643300979_0002
+ Lob Location : /user/trafodion/lobs
+ LOB Data File: LOBP_00452177305498070471_0002
LOB EOD : 15
LOB Used Len : 15
ColumnName : C4
- Lob Location : /lobs
- LOB Data File: LOBP_00183086508643300979_0003
+ Lob Location : /user/trafodion/lobs
+ LOB Data File: LOBP_00452177305498070471_0003
LOB EOD : 45
LOB Used Len : 45
@@ -1132,9 +1116,9 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
CATALOG_NAME SCHEMA_NAME OBJECT_NAME COLUMN_NAME
LOB_LOCATION LOB_DATA_FILE LOB_DATA_FILE_SIZE_EOD LOB_DATA_FILE_SIZE_USED
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------- -----------------------
-TRAFODION LOB130 TLOB130GT C2
/lobs LOBP_00183086508643300979_0001 15 15
-TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_00183086508643300979_0002 15 15
-TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_00183086508643300979_0003 45 45
+TRAFODION LOB130 TLOB130GT C2
/user/trafodion/lobs LOBP_00452177305498070471_0001 15 15
+TRAFODION LOB130 TLOB130GT C3
/user/trafodion/lobs LOBP_00452177305498070471_0002 15 15
+TRAFODION LOB130 TLOB130GT C4
/user/trafodion/lobs LOBP_00452177305498070471_0003 45 45
--- 3 row(s) selected.
>>delete from tlob130gt where c1=2;
@@ -1150,18 +1134,18 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
=========================
ColumnName : C2
- Lob Location : /lobs
- LOB Data File: LOBP_00183086508643300979_0001
+ Lob Location : /user/trafodion/lobs
+ LOB Data File: LOBP_00452177305498070471_0001
LOB EOD : 30
LOB Used Len : 25
ColumnName : C3
- Lob Location : /lobs
- LOB Data File: LOBP_00183086508643300979_0002
+ Lob Location : /user/trafodion/lobs
+ LOB Data File: LOBP_00452177305498070471_0002
LOB EOD : 31
LOB Used Len : 26
ColumnName : C4
- Lob Location : /lobs
- LOB Data File: LOBP_00183086508643300979_0003
+ Lob Location : /user/trafodion/lobs
+ LOB Data File: LOBP_00452177305498070471_0003
LOB EOD : 71
LOB Used Len : 56
@@ -1171,9 +1155,9 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130GT
CATALOG_NAME SCHEMA_NAME OBJECT_NAME COLUMN_NAME
LOB_LOCATION LOB_DATA_FILE LOB_DATA_FILE_SIZE_EOD LOB_DATA_FILE_SIZE_USED
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------- -----------------------
-TRAFODION LOB130 TLOB130GT C2
/lobs LOBP_00183086508643300979_0001 30 25
-TRAFODION LOB130 TLOB130GT C3
/lobs LOBP_00183086508643300979_0002 31 26
-TRAFODION LOB130 TLOB130GT C4
/lobs LOBP_00183086508643300979_0003 71 56
+TRAFODION LOB130 TLOB130GT C2
/user/trafodion/lobs LOBP_00452177305498070471_0001 30 25
+TRAFODION LOB130 TLOB130GT C3
/user/trafodion/lobs LOBP_00452177305498070471_0002 31 26
+TRAFODION LOB130 TLOB130GT C4
/user/trafodion/lobs LOBP_00452177305498070471_0003 71 56
--- 3 row(s) selected.
>>
@@ -1182,49 +1166,52 @@ TRAFODION
>>create table tlob130ext (c1 int not null, c2 blob, c3 clob, c4 blob storage 'external', primary key (c1));
--- SQL operation complete.
+>>
>>create table tlob130ext2 (c1 int not null, c2 blob, c3 clob, c4 blob storage 'external', primary key (c1));
--- SQL operation complete.
>>create table tlob130_not_external (c1 int not null , c2 blob, c3 blob, c4 blob, primary key (c1));
--- SQL operation complete.
->>insert into tlob130ext values(1, stringtolob('first lob'), filetolob('hdfs:///lobs/lob_input_a1.txt'),externaltolob('hdfs:///lobs/lob_input_a1.txt'));
+>>insert into tlob130ext values(1, stringtolob('first lob'), filetolob('hdfs:///user/trafodion/lobs/lob_input_a1.txt'),externaltolob('hdfs:///user/trafodion/lobs/lob_input_a1.txt'));
--- 1 row(s) inserted.
->>insert into tlob130ext values(2, stringtolob('second lob'), filetolob('hdfs:///lobs/lob_input_b1.txt'),externaltolob('hdfs:///lobs/lob_input_b1.txt'));
+>>insert into tlob130ext values(2, stringtolob('second lob'), filetolob('hdfs:///user/trafodion/lobs/lob_input_b1.txt'),externaltolob('hdfs:///user/trafodion/lobs/lob_input_b1.txt'));
--- 1 row(s) inserted.
->>insert into tlob130ext values(3, stringtolob('third lob'), filetolob('hdfs:///lobs/lob_input_c1.txt'),externaltolob('hdfs:///lobs/lob_input_c1.txt'));
+>>insert into tlob130ext values(3, stringtolob('third lob'), filetolob('hdfs:///user/trafodion/lobs/lob_input_c1.txt'),externaltolob('hdfs:///user/trafodion/lobs/lob_input_c1.txt'));
--- 1 row(s) inserted.
+>>
>>--negative cases
->>insert into tlob130ext values(2, externaltolob('first lob'), filetolob('hdfs:///lobs/lob_input_a1.txt'),externaltolob('hdfs:///lobs/lob_input_a1.txt'));
+>>insert into tlob130ext values(2, externaltolob('first lob'), filetolob('hdfs:///user/trafodion/lobs/lob_input_a1.txt'),externaltolob('hdfs:///user/trafodion/lobs/lob_input_a1.txt'));
*** ERROR[1432] Input LOB type 8 does not match column's storage type: 2 Column name: C2 .
*** ERROR[8822] The statement was not prepared.
->>insert into tlob130ext values(3, stringtolob('first lob'), filetolob('hdfs:///lobs/lob_input_a1.txt'),filetolob('hdfs:///lobs/lob_input_a1.txt'));
+>>insert into tlob130ext values(3, stringtolob('first lob'), filetolob('hdfs:///user/trafodion/lobs/lob_input_a1.txt'),filetolob('hdfs:///user/trafodion/lobs/lob_input_a1.txt'));
*** ERROR[1432] Input LOB type 2 does not match column's storage type: 8 Column name: C4 .
*** ERROR[8822] The statement was not prepared.
->>update tlob130ext set c4=stringtolob('hdfs:///lobs/lob_input_a1.txt', append) where c1=1;
+>>update tlob130ext set c4=stringtolob('hdfs:///user/trafodion/lobs/lob_input_a1.txt', append) where c1=1;
*** ERROR[1432] Input LOB type 2 does not match column's storage type: 8 Column name: C4 .
*** ERROR[8822] The statement was not prepared.
->>update tlob130ext set c4=externaltolob('hdfs:///lobs/lob_input_a1.txt', append) where c1=1;
+>>update tlob130ext set c4=externaltolob('hdfs:///user/trafodion/lobs/lob_input_a1.txt', append) where c1=1;
*** ERROR[15001] A syntax error occurred at or before:
-update tlob130ext set c4=externaltolob('hdfs:///lobs/lob_input_a1.txt', append)
- ^ (79 characters from start of SQL statement)
+update tlob130ext set c4=externaltolob('hdfs:///user/trafodion/lobs/lob_input_a
+1.txt', append) where c1=1;
+ ^ (94 characters from start of SQL statement)
*** ERROR[8822] The statement was not prepared.
->>update tlob130ext set c3=externaltolob('hdfs:///lobs/lob_input_b1.txt') where c1=1;
+>>update tlob130ext set c3=externaltolob('hdfs:///user/trafodion/lobs/lob_input_b1.txt') where c1=1;
*** ERROR[1432] Input LOB type 8 does not match column's storage type: 2 Column name: C3 .
@@ -1239,18 +1226,18 @@ update tlob130ext set c4=externaltolob('hdfs:///lobs/lob_input_a1.txt', append)
>>delete from tlob130ext where c1=1;
--- 1 row(s) deleted.
->>insert into tlob130ext values(1, stringtolob('first lob'),externaltolob('hdfs:///lobs/lob_input_a1.txt'),externaltolob('hdfs:///lobs/lob_input_a1.txt'));
+>>insert into tlob130ext values(1, stringtolob('first lob'),externaltolob('hdfs:///user/trafodion/lobs/lob_input_a1.txt'),externaltolob('hdfs:///user/trafodion/lobs/lob_input_a1.txt'));
*** ERROR[1432] Input LOB type 8 does not match column's storage type: 2 Column name: C3 .
*** ERROR[8822] The statement was not prepared.
->>insert into tlob130ext values(1, stringtolob('first lob'), filetolob('hdfs:///lobs/lob_input_a1.txt'),externaltolob('hdfs:///lobs/lob_input_a1.txt'));
+>>insert into tlob130ext values(1, stringtolob('first lob'), filetolob('hdfs:///user/trafodion/lobs/lob_input_a1.txt'),externaltolob('hdfs:///user/trafodion/lobs/lob_input_a1.txt'));
--- 1 row(s) inserted.
>>-- the next one should see error 8557
->>insert into tlob130ext values(1, stringtolob('first lob'), filetolob('hdfs:///lobs/lob_input_a1.txt'),
-+>externaltolob('hdfs:///lobs/reallyLongDirectoryName0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789/lob_input_a1012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789.txt'));
+>>insert into tlob130ext values(1, stringtolob('first lob'), filetolob('hdfs:///user/trafodion/lobs/lob_input_a1.txt'),
++>externaltolob('hdfs:///user/trafodion/lobs/reallyLongDirectoryName0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789/lob_input_a1012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789.txt'));
*** ERROR[8557] The file name passed to externaltolob exceeds 256 bytes.
@@ -1268,7 +1255,8 @@ second lob The cat and the fiddle,
The cat and the fiddle,
third lob The cow jumped over the moon.
- The cow jumped over the moon.
+ The cow jumped over the moon.
+
--- 3 row(s) selected.
>>update tlob130ext set c3=stringtolob('can allow this') where c1=1;
@@ -1285,13 +1273,14 @@ second lob The cat and the fiddle,
The cat and the fiddle,
third lob The cow jumped over the moon.
- The cow jumped over the moon.
+ The cow jumped over the moon.
+
--- 3 row(s) selected.
>>
>>
>>
->>update tlob130ext set c4=externaltolob('hdfs:///lobs/lob_input_d1.txt') where c1=2;
+>>update tlob130ext set c4=externaltolob('hdfs:///user/trafodion/lobs/lob_input_d1.txt') where c1=2;
--- 1 row(s) updated.
>>select lobtostring(c2,50),lobtostring(c3,50),lobtostring(c4,50) from tlob130ext;
@@ -1307,12 +1296,13 @@ To see such sport,
And th
third lob The cow jumped over the moon.
- The cow jumped over the moon.
+ The cow jumped over the moon.
+
--- 3 row(s) selected.
>>
>>
->>update tlob130ext set c2=filetolob('hdfs:///lobs/lob_input_b1.txt') where c1=2;
+>>update tlob130ext set c2=filetolob('hdfs:///user/trafodion/lobs/lob_input_b1.txt') where c1=2;
--- 1 row(s) updated.
>>select lobtostring(c2,50),lobtostring(c3,50),lobtostring(c3,50) from tlob130ext;
@@ -1337,13 +1327,13 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130EXT
=========================
ColumnName : C2
- Lob Location : /lobs
- LOB Data File: LOBP_00183086508643314774_0001
+ Lob Location : /user/trafodion/lobs
+ LOB Data File: LOBP_00452177305498099204_0001
LOB EOD : 70
LOB Used Len : 42
ColumnName : C3
- Lob Location : /lobs
- LOB Data File: LOBP_00183086508643314774_0002
+ Lob Location : /user/trafodion/lobs
+ LOB Data File: LOBP_00452177305498099204_0002
LOB EOD : 125
LOB Used Len : 68
ColumnName : C4
@@ -1358,8 +1348,8 @@ Lob Information for table: "TRAFODION".LOB130.TLOB130EXT
CATALOG_NAME SCHEMA_NAME OBJECT_NAME COLUMN_NAME
LOB_LOCATION LOB_DATA_FILE LOB_DATA_FILE_SIZE_EOD LOB_DATA_FILE_SIZE_USED
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------- -----------------------
-TRAFODION LOB130 TLOB130EXT C2
/lobs LOBP_00183086508643314774_0001 70 42
-TRAFODION LOB130 TLOB130EXT C3
/lobs LOBP_00183086508643314774_0002 125 68
+TRAFODION LOB130 TLOB130EXT C2
/user/trafodion/lobs LOBP_00452177305498099204_0001 70 42
+TRAFODION LOB130 TLOB130EXT C3
/user/trafodion/lobs LOBP_00452177305498099204_0002 125 68
TRAFODION LOB130
<TRUNCATED>