Hi,
I have been trying to work through the tutorial posted here,
and I haven't been having much luck.
When I try to run author_dimension.ctl I get the following error.
******************
F:\ruby_testing\DW\rails_warehouse\db\etl>etl author_dimension.ctl
Using AdapterExtensions
Starting ETL process
initializing ETL engine
Processing author_dimension.ctl
Executing screens
Screens passed
Executing post processes
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.1/lib/active_record/connecti
on_a
dapters/abstract_adapter.rb:150:in `log': Mysql::Error: #42000The used
command i
s not allowed with this MySQL version: LOAD DATA LOCAL INFILE
'./author_dimensio
n.txt' INTO TABLE author_dimension FIELDS TERMINATED BY ',' (name)
(ActiveRecord
::StatementInvalid)
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.1/lib/active_record
/connection_adapters/mysql_adapter.rb:281:in `execute'
from
c:/ruby/lib/ruby/gems/1.8/gems/adapter_extensions-0.4.0/lib/adapter
_extensions/connection_adapters/mysql_adapter.rb:46:in `do_bulk_load'
from
c:/ruby/lib/ruby/gems/1.8/gems/adapter_extensions-0.4.0/lib/adapter
_extensions/connection_adapters/abstract_adapter.rb:18:in `bulk_load'
from
c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/../lib
/etl/processor/bulk_import_processor.rb:68:in `process'
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.0.1/lib/active_record
/connection_adapters/abstract/database_statements.rb:66:in `transaction'
from
c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/../lib
/etl/processor/bulk_import_processor.rb:58:in `process'
from
c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/../lib
/etl/engine.rb:485:in `post_process'
from
c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/../lib
/etl/engine.rb:484:in `each'
... 13 levels...
from
c:/ruby/lib/ruby/gems/1.8/gems/activesupport-2.0.1/lib/active_suppo
rt/dependencies.rb:496:in `require'
from
c:/ruby/lib/ruby/gems/1.8/gems/activewarehouse-etl-0.9.0/bin/etl:28
from c:/ruby/bin/etl:16:in `load'
from c:/ruby/bin/etl:16
******************
This is my environment:
Windows XP Pro SP2.
rails -v => 2.0.1
ruby -v => ruby 1.8.6 (2007-03-13 patchlevel 0) [i386-mswin32]
gem -v => 0.9.4
MySQL 'select @@version;' => 5.0.27-community-nt
If I run the command "LOAD DATA LOCAL INFILE './author_dimension.txt' INTO
TABLE author_dimension FIELDS TERMINATED BY ',' (name);" directly in MySQL,
then the data imports just fine. (Actually it is not completely fine, it I
get line breaks at the end of some of the strings.)
Any ideas?
Thanks,
Paul
_______________________________________________
Activewarehouse-discuss mailing list
Activewarehouse-discuss@rubyforge.org
http://rubyforge.org/mailman/listinfo/activewarehouse-discuss
