Recent changes to feature-requests

Specyfying data files from select statement

2009-09-17T03:57:25Z

As a user, I want to specify some data files when select data from table. like below, I want to select data from specified files in directory not entire table(data directory):

I have a table 'test_table9' and the table has data files in data directroy (e.g. /user/hadoop/cloudbase/data/TEST_TABLE9/)
Files in that directory:
data1.txt
data2.txt
data3.txt

SELECT * FROM test_table9 DATAFILE ('data1.txt', 'data2.txt') WHERE col1='...';

Export data into RDBMS table using JDBC Batch update

2009-09-17T03:33:33Z

JDBC batch update is faster than single update per row. I could see 5x performance improvement in some cases on our cluster. I just replace 'executeUpdate( )' with 'addBatch()' and 'executeBatch()'. and I call the 'executeBatch()' per file. and This is a straitforward implementation. I do not consider 'batch size', 'commit size' or something like that. but it works fine so far.

I think we can configure the batch size for export in Cloudbase's configuration.

DB objects with reserved keywords as names should be allowed

2009-07-09T06:58:30Z

Tables, columns, and indexes with reserved keywords (eg. 'url') as names should be allowed.

Add commands to select CloudBase metadata

2009-06-25T02:11:42Z

It would be nice CloudBase supports commands for listing metadata.
We can select data about Tables, Views, UDFs, UDTs and DBLINKs using the commands.

Bulk loader for CloudBase using a Database link.

2009-06-08T06:42:31Z

CloudBase supports database links only for exporting results into the RDBMS' table.
It would be nice to be able to import data from RDBMS table to CB table using a database link and vise versa.

FYI, http://www.cloudera.com/blog/2009/06/01/introducing-sqoop/

Support of 'ALTER TABLE' statement.

2009-06-08T06:25:30Z

Syntax format:
ALTER TABLE <table name> <alter table action>

Alter table actions:
rename table
add/drop column
...

Support for NULL on SELECT statement.

2009-06-08T06:11:39Z

CloudBase supports NULL. but NULL on 'SELECT' statement does not work.

Query:
select c1, NULL from test_table1;

The query returns an error.

CONVERT from DATETIME to VARCHAR with conversion mask

2009-03-31T02:18:35Z

Hi,

CloudBase supports CONVERT function however conversion mask supports only in case from VARCHAR to DATETIME.
I'd like to use conversion mask when converting to VARCHAR from DATETIME.
Or supporting 'Date Formatting' would be a possible approach - DATETIME -> Date Formatting -> VARCHAR

Thanks,

Youngwoo

Need to be able to set the password

2009-03-16T21:52:27Z

Currently there doesn't seem to be anything to change administrative password or add user names.

Currently I can't lock other people out of CloudBase's ODBC connection, since it has the same user name on all installations. To alleviate this, the ability to change passwords would be helpful (and possibly create other users, even though there's no permission enforcement - this would be useful for logging).

Index information on SQuirreL' Objects Tab

2009-03-14T02:22:33Z

Hi,

There are no index information on SQuirreL' Objects Tab. I'd like to see the index list on SQuirreL SQL Client.

Thanks,

Youngwoo